excel VBA LISTBOX初始化代码

Private Sub UserForm_Initialize()
Dim lsb As Worksheet
Set lsb = Sheets("临时表")
X = lsb.[a65536].End(3).Row
With ListBox1
.ColumnCount = 7 ‘设置7列
.ColumnWidths = "30,70,70,70,70,70,50" ‘设置每列宽度

.ColumnHeads = True ‘是否有标题表头
.RowSource = lsb.Range("a2:g" & X).Address(External:=True) ‘设置内容
End With
End Sub

office办公软件入门基础教程 » excel VBA LISTBOX初始化代码

本文链接:【excel VBA LISTBOX初始化代码】https://www.officeapi.cn/34469.html

OFFICE,天天学一点,进步多一点

联系我们