Limit Combo Box Selections / Custom Error Message

[mharper90]

I have a Combo Box on a User Form with a dynamic items list (gathers the item list from a spreadsheet based on active cell value when the user form activates). How can I make it so that the user must choose one of the options from the Combo Box (no manual typed entry)? IF manual typed entry must be allowed, how can I display a custom error message if the user entered a value that doesn't match the possible options from the items list?

 

[Fluff]

Set the match entry property of the combo to 1-fmMatchEntryComplete