Limiting values in comboboxes.
 

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

Limiting values in comboboxes.
 

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

Limiting values in comboboxes.
 

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