filmov
tv
Excel VBA UserForm Combobox Clear All Items

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