filmov
tv
Excel VBA UserForm Combobox with Multiple Columns Populate (Column Property)
![preview_player](https://i.ytimg.com/vi/LlE1u7coRVc/maxresdefault.jpg)
Показать описание
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