Validating values in a userform combox.

[Aorusakwe]

Hello,
I have successfully made a userform in excel 2010, but I am having issues with the comboboxes . I have populated them with list using the Rowsource function but when using the form you can still type things that aren't included in the list and it accepts it. I have added data validation to the spreadsheet but that the macro overrides it. I also tired the following IF Not statement

If Not Me.cboPilot.Value = Pilot Then
MsgBox "Please select a value from Pilot drop down list.", vbExclamation, "New Item"
Me.cboPilot.SetFocus
Exit Sub
End If
Where Pilot= list of cells (used name manager to accomplish this)

If anyone has any ideas or can tell me where I went wrong I greatly appreciate it.

thanks

[Kenneth Hobson]

Set The combobox Property MatchRequired's value to True.

[Aorusakwe]

Wow I can't believe it was that simple thanks