| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down List w/ Values Pop Automacailly when choose entry from l | Excel Discussion (Misc queries) | |||
| how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
| Validation list that also allows user entry? | Excel Worksheet Functions | |||
| Can a user select more than one entry in a drop down list? | Excel Worksheet Functions | |||
| Text shifts left in Excel Combo Box when user types in entry | Excel Discussion (Misc queries) | |||
Threaded Mode
