Userform Help

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
 
N

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
[email protected]
 
A

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
 
Top