Mika,

Change the combobox's Style property to 2, fmStyleDropDownList.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"mika." wrote in message
...
Hi,

How do I not allow the user to enter something into a
combobox? I have 5 values in my combobox, and I want to
ensure that the user doesn't type something else into the
combobox - so that they are restricted to only choosing
one of the values in the combobox list.

Thanks!
Mika