Automatic cell validation prefill by entering first letter
 

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. :)

Automatic cell validation prefill by entering first letter
 

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. :)

Automatic cell validation prefill by entering first letter
 

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

"JB" wrote:

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. :)

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. :)

Automatic cell validation prefill by entering first letter
 

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.

"JB" wrote:

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. :)