Automatic cell validation prefill by entering first letter

  • Thread starter Thread starter Guest
  • Start date Start date
G

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. :)
 
You can't do that with validation, the combobox from the control toolbox can
be configured to do that
 
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?
 
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.
 
Back
Top