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