Userform Help

  • Thread starter Thread starter Axcell
  • Start date Start date
A

Axcell

Hello,

How could I prevent users from entering text manually into the comb
boxes on my userforms and to just select the available text from th
pull down menu.

Thanks
 
You could set the MatchRequired property of the combobox to true. This
prevents users leaving the control until they match an entry in the list

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Nick,

Thanks for the fix, it was what I was looking for.

One question, though it's not really a big deal.

If the user does type text into the box and gets the "Invalid Propert
Value" and wishes to quit/cancel form, is there a way to break out o
the error message that continues to come up even after you delete th
text that was typed in?


Ale
 
Back
Top