Automatic cell validation prefill by entering first letter

[Guest]

Hi
I have set up a dropdown list validation in a cell. I would like to set it
up so that users can type the first letter of the option they want in the
cell and have it prefill the first option in the list that begins with that
letter. Is this possible?
Thank you for any help you can provide.

 

[Peo Sjoblom]

You can't do that with validation, the combobox from the control toolbox can
be configured to do that

 

[Guest]

Contextures has some good info on this:
http://www.contextures.com/xlDataVal10.html

 

[Guest]

Thanks Peo! I've changed it over to a combobox, the only problem I'm having
now is that i can't get it so that users can get to it by hitting tab, like
in a form (not just by using the mouse) Any ideas?

 

[Guest]

Haven't got time right this minute to layout the code, but I'm thinking that
if you use the worksheet's _SelectionChange event processing to see if
someone has tabbed into a specific cell and when they do that have the
'focus' set to the combo box?

Need help with the code, post back.