Combo Box that allows user entry of values not on drop-down list

D

donnadelayed

I'm creating a form that requires some drop-down menus. However, I want
users to be able to type in their own entries if the choices in the drop-down
lists are not applicable. From what I can see in Excel Help, I need to use a
Combo Box with Active X control. Then, it says to go to Properties (in
Design Mode) and set Style to "1" to allow users to enter new values not on
the list. But the only choices available in Style are 0 and 2! Excel Help
even says that 1 is the default! I even changed MaxLength from 0 to 15.
Please help asap. Thanks.
 
J

Jim Thomlinson

Set the style to 0 for a drop down combo. That will allow the user to free
type in the box. Your other option would be to use in cell validation with a
list. You just need to uncheck "Show alert when invalid data is entered" on
the Alert tab...
 

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

Filtered drop down list 2
produce list automatically from choice of drop down list 1
Excel Drop Down Box 2
Drop Down Lists 2
Linking drop down lists to another list 4
Drop Down List 3
Customise drop down list validation 3
Restrict Choice in Shared WB (drop down alternative)? 0

Top