Data Validation list selection question
 

I have a cell with 352 entries for a user to choose (data validation list).

Is it possible to have the user type the first letter to speed up the
selection
process, that is, type "L" and the list will jump to the first entry
beginning with "L" rather than scrolling the entire list with the mouse?

As always, thanks in advance.

BW

Not using data|Validation, but maybe you could use a combobox from the control
toolbox toolbar???

Bob Wall wrote:

I have a cell with 352 entries for a user to choose (data validation list).

Is it possible to have the user type the first letter to speed up the
selection
process, that is, type "L" and the list will jump to the first entry
beginning with "L" rather than scrolling the entire list with the mouse?

As always, thanks in advance.

BW

--

Dave Peterson

You can copy the range that that is the source for the
validation list either directly below or above the
validation cell. Also make sure AutoComplete is enabled
under Tools Options Edit tab "Enable AutoComplete
for cell values.

You can then hide the cells with a custom format of ;;; .

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a cell with 352 entries for a user to choose (data
validation list).

Is it possible to have the user type the first letter to
speed up the
selection
process, that is, type "L" and the list will jump to the
first entry
beginning with "L" rather than scrolling the entire list
with the mouse?

As always, thanks in advance.

BW


.