Private Sub CommandButton1_Click() Dim Arr, Col% With Sheets("Sheet3") Arr = .UsedRange Col = .UsedRange.Columns.Count End With With Me.ListBox1 .ColumnCount = Col .List() = Arr End With End Sub
Private Sub CommandButton1_Click() Dim Arr, Col% With Sheets("Sheet3") Arr = .UsedRange Col = .UsedRange.Columns.Count End With With Me.ListBox1 .ColumnCount = Col .List() = Arr End With End Sub
Private Sub CommandButton1_Click() Dim Arr, Col% With Sheets("Sheet3") Arr = .UsedRange '把要显示的行和列赋值给数组 Col = .UsedRange.Columns.Count '求出列表的列数 End With With Me.ListBox1 .ColumnCount = Col '列表显示的列数 .List() = Arr '数组赋值给列表 End With End Sub