请教,Excel VBA中列表框使用问题。谢谢!

2025-03-23 08:46:00
推荐回答(1个)
回答1:

贴来的:
Private Sub ListBox1_Change()

Dim Mydata()

AA = ListBox1.ListCount - 1

ReDim Mydata(AA, 1)

Mydata = ListBox1.List()
ListBox2.List() = Mydata

For i = ListBox1.ListCount - 1 To 0 Step -1
If Not ListBox1.Selected(i) Then ListBox2.RemoveItem i
Next
End Sub