Limiting values in comboboxes.

[mika.]

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

 

[Chip Pearson]

Mika,

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


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

 

[Ron de Bruin]

Hi Mika

Change Style in the properties of the combobox to 2