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