I am putting together a spreadsheet that is using data validation to create
drop down lists for the user to choose from when entering data. Only thing
is that it doesn't allow them to use the keyboard to "jump to" the letter of
the alphabet that the item they are looking for begins with. (for example,
when going to enter the "State" they click on the cell, the drop down list
comes up, but they can't type "n" and have the selection jump to the letter
"n" in the data list.

Is there another approach that allows this feature?

Thanks in advance,

ad108

Hi AD108,

See:

http://www.contextures.com/xlDataVal10.html


---
Regards,
Norman


"AD108" wrote in message
...
I am putting together a spreadsheet that is using data validation to create
drop down lists for the user to choose from when entering data. Only
thing
is that it doesn't allow them to use the keyboard to "jump to" the letter
of
the alphabet that the item they are looking for begins with. (for
example,
when going to enter the "State" they click on the cell, the drop down list
comes up, but they can't type "n" and have the selection jump to the
letter
"n" in the data list.

Is there another approach that allows this feature?

Thanks in advance,

ad108

Thanks very much Norman

"Norman Jones" wrote in message
...
Hi AD108,

See:

http://www.contextures.com/xlDataVal10.html


---
Regards,
Norman


"AD108" wrote in message
...
I am putting together a spreadsheet that is using data validation to
create
drop down lists for the user to choose from when entering data. Only
thing
is that it doesn't allow them to use the keyboard to "jump to" the
letter
of
the alphabet that the item they are looking for begins with. (for
example,
when going to enter the "State" they click on the cell, the drop down
list
comes up, but they can't type "n" and have the selection jump to the
letter
"n" in the data list.

Is there another approach that allows this feature?

Thanks in advance,

ad108