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

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.

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

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...
--
HTH...

Jim Thomlinson


"donnadelayed" wrote:

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.