filmov
tv
Excel VBA UserForm Combobox with Multiple Columns Populate (Column Property)
Показать описание
Excel VBA UserForm Learn how to populate Combobox with multiple columns (Column Property)
The source code used in this video:
Private Sub UserForm_Initialize()
With cbDays
.ColumnCount = 2
.AddItem "12/01/2015"
.Column(1, 0) = "Monday"
.AddItem "13/01/2015"
.Column(1, 1) = "Tuesday"
.AddItem "14/01/2015"
.Column(1, 2) = "Wednesday"
End With
End Sub
The source code used in this video:
Private Sub UserForm_Initialize()
With cbDays
.ColumnCount = 2
.AddItem "12/01/2015"
.Column(1, 0) = "Monday"
.AddItem "13/01/2015"
.Column(1, 1) = "Tuesday"
.AddItem "14/01/2015"
.Column(1, 2) = "Wednesday"
End With
End Sub