Limiting values in comboboxes.

M

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
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

populate a combobox based on unique values in another workbook 16
Combobox filtering 2
Iterating through a ComboBox's values 6
active combobox - possible to configure as display value andcoordinate value? 3
Ensuring Combobox has Value entered if another ComboBox has aspecific value 3
non-repeating Comboboxes values 9
Blank Spaces on ComboBox 2
Userform combobox matchrequired = True; error with no selection 5

Top