Excel VBA UserForm Combobox with Multiple Columns Populate (Column Property)

preview_player
Показать описание
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
Рекомендации по теме