View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JB JB is offline
external usenet poster
 
Posts: 115
Default Automatic cell validation prefill by entering first letter

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?

"Peo Sjoblom" wrote:

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

--
Regards,

Peo Sjoblom


"JB" wrote in message
...
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. :)