Excel VBA UserForm Combobox Clear All Items

preview_player
Показать описание
Excel VBA UserForm Combobox Learn how to clear all the items

The source code used in this video:

Private Sub cbRemove_Click()
cbDays.RemoveItem 0
End Sub

Private Sub cbRemoveAll_Click()
cbDays.Clear
End Sub

Private Sub UserForm_Initialize()
With cbDays
.AddItem "Monday"
.AddItem "Tuesday"
.AddItem "Wednesday"
End With
End Sub
Рекомендации по теме