第二种:List属性 可用 List 把值的完整的二维数组复制到列表框控件上 利用该属性,还有以下二种方式可选择: A、利用数组  rivate Sub UserForm_Initialize() Dim Arr0 Dim Erow As Integer Erow = Worksheets("Columns").Range("A65536").End(xlUp).Row Arr0 = Worksheets("Columns").Range("A2:C" & Erow) With Me.ListBox1 .ColumnCount = 3 .BackColor = &HFFFF00 .ColumnWidths = "80,50,30" .List = Arr0 End With End Sub B、用命名的单元格 Private Sub UserForm_Initialize() ActiveWorkbook.Names.Add Name:="ListValue", RefersToR1C1:= _ "=OFFSET(Columns!R2C1,,,COUNTA(Columns!C1)-1,3)" With Me.ListBox1 .ColumnCount = 3 .BackColor = &HFFFF00 .ColumnWidths = "80,50,30" .List = Range("ListValue").Value End With End Sub |