Dim l As Long '表示行数时,应该习惯设成长整型
l = Sheets("设置表").Range("A65536").End(xlUp).Row
Sub OkExcel01()
'www.okexcel.com.cn
Dim l As Long '表示行数时,应该习惯设成长整型
Dim i As Long
Dim ws As Worksheet
Set ws = Worksheets("设置表")
l = ws.Range("A65536").End(xlUp).Row
For i = 2 To l
ComboBox1.AddItem (ws.Cells(i, 1))
Next
End Sub
Sub OkExcel02()
'www.okexcel.com.cn
Dim l As Long
Dim ws As Worksheet
Set ws = Worksheets("设置表")
l = ws.Range("A65536").End(xlUp).Row
ComboBox1.List = ws.Range("A2:A" & l).Value
End Sub
Sub OkExcel03_1()
'www.okexcel.com.cn
Dim l As Long
Dim ws As Worksheet
Set ws = Worksheets("设置表")
l = ws.Range("A65536").End(xlUp).Row
ThisWorkbook.Names("类别").RefersTo = "=设置表!$A$2:$A$" & l
End Sub
Sub OkExcel03_2()
'www.okexcel.com.cn
ComboBox1.List = ThisWorkbook.Names("类别").RefersToRange.Value
End Sub
联系客服