I have setup a drop down list using Data validation. My challenge is to
select the items in the list by entering the first letter of the word in the
list. For example to choose Bear in the list I would enter "B" and it would
take me to the first entry with a "B".

Thanks in advance.

Richard

For that, you have to use a ComboBox from the Control Toolbox toolbar
instead of Data Validation.

--
Regards

Juan Pablo González

"ROK" wrote in message
...
I have setup a drop down list using Data validation. My challenge is to
select the items in the list by entering the first letter of the word in
the
list. For example to choose Bear in the list I would enter "B" and it
would
take me to the first entry with a "B".

Thanks in advance.

Richard