Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combo box
Good afternoon!
I have a combo box that is set up with a linked cell and code to follow on a change event. Before the code was added, users could star typing in the combo box and the nearest match would appear in the box. For example if a part number available is 3400S, a user could start typing 340 and the rest would pop into the box. When I added the change event code, once a single number or letter is entered, the change event code is initiated and the user cannot continue typing a second or third number to get closer to a match. Obviously if they just use the drop down, there is no problem...but the list is really to long to scroll through. Is there a way to make it a selection event, rather than a change event or some other way to allow users to enter more than 1 number? Any help is greatly appreciated. thank you! brenda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
Dynamic Combo Box | Excel Worksheet Functions | |||
connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions |