VBA中的列表框可以通過以下方法賦值:
ListBox1.AddItem "Item 1"
ListBox1.AddItem "Item 2"
ListBox1.AddItem "Item 3"
ListBox1.List = Array("Item 1", "Item 2", "Item 3")
Dim i As Integer
For i = 1 To 3
ListBox1.AddItem "Item " & i
Next i
Dim rng As Range
Set rng = Sheet1.Range("A1:A3")
ListBox1.List = rng.Value
請根據您的具體需求選擇適合的方法進行賦值。