|
楼主 |
发表于 2019-5-26 13:51
|
显示全部楼层
放在这里自我欣赏,不喜勿喷
- Sub 动态增加ListBox1()
- Set x = ActiveSheet.OLEObjects.Add(ClassType:="Forms.ListBox.1", Link:=False, _
- DisplayAsIcon:=False, Left:=435.6, Top:=30, Width:=115.8, Height:=135)
- With x '各句是有顺序的,不能乱
- .Object.ListStyle = 1
- '.Object.MultiSelect = 1
- '.ListFillRange = "$A$1:$A$5" ''正确写法
- For Each Cel In Sheets("Lists").Range("A1:A4").Cells
- .Object.AddItem Cel.Value2
- Next Cel
- .LinkedCell = "I1" '如果MultiSelect=1就没用了,不能写在MultiSelect之后,
- .Activate '有这一句,才起作用
- End With
- End Sub
- Sub 动态增加ListBox2()
- Dim i, arr
- arr = Array("A1", "A2", "A3")
- Set x = ActiveSheet.OLEObjects.Add(ClassType:="Forms.ListBox.1", Link:=False, _
- DisplayAsIcon:=False, Left:=435.6, Top:=T, Width:=90, Height:=135)
- With x '各句是有顺序的,不能乱
- .Object.ListStyle = 1
- '.Object.MultiSelect = 1
- '.ListFillRange = "$A$1:$A$5" ''正确写法
- For i = LBound(arr) To UBound(arr)
- .Object.AddItem arr(i)
- Next
- .LinkedCell = Range("I1").Address '如果MultiSelect=1就没用了,不能写在MultiSelect之后,
- .Activate '有这一句,才起作用
- End With
- End Sub
复制代码 |
|