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

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

Hi Mika

Change Style in the properties of the combobox to 2

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"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