Excel UserForm Validate ComboBox (VBA)
Learn how to validate UserForm ComboBox in Excel VBA.
The code used in this video:
Private Sub cbSave_Click()
If cbColours.ListIndex = -1 Then
MsgBox "You must select Colour"
Exit Sub
End If
End Sub
Private Sub UserForm_Initialize()
With cbColours
.AddItem "Red"
.AddItem "Blue"
.AddItem "Green"
End With
End Sub
Watch video Excel UserForm Validate ComboBox (VBA) online without registration, duration hours minute second in high quality. This video was added by user InAnOffice 07 February 2014, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,921 once and liked it 13 people.