View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave D[_3_] Dave D[_3_] is offline
external usenet poster
 
Posts: 6
Default ComboBox and Set Focus

You can set matchrequired property so that they can only
pick from the list.

You could use the keyup event to check the character just
entered to display a msgbox with an error message and
then delete the last character entered. Probabley easier
to check the text when they leave the box (less overhead)
and then set focus back to the control they just left.