Userform Help

[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

 

[Nick Hodge]

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)

 

[Axcell]

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