View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hurlbut777 hurlbut777 is offline
external usenet poster
 
Posts: 32
Default Use VBA code to display message if combobox selection not in list

When using combo box to display drop-down list, users can actually type in
any value they want...not good for what I need. A feasible fix for this is
to verify that the value typed in the combo box is in a list...if it isn't
display a message that says Try Again.

Based on the list below, what would the VBA code look like that says if
combo box value is not in list then give error message?

List: Monday, Tuesday, Wednesday