Question about lists ?

[le clef]

Hello all

I use a drop down list to allow users of a worksheet to select customer names.

Is it possible to open the list and press the first letter of the customer
name and be taken to the first occurance of that letter to save having to
scroll down the entire list ?

My thanks in anticipation

Nigel.

 

[Debra Dalgleish]

That's not possible in a standard data validation list. You can use a
combo box instead, as described here:

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

Or add letters in the source list, as shown in Roger Govier's sample
file here:

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

Under Data Validation, look for 'DV0046 - Add Headings for Navigation'

 

[Max]

Debra,

Re: 'DV0046 - Add Headings for Navigation'

When I followed Step 2:
to type in the 1st letter into B3, then click the down arrow
Excel threw up the standard DV error message
(The value you entered is not valid ...)
instead of the list opening at the letter I typed ??

Several tries in several other DV cells gave the same result
What can I do to make it work?

---

 

[Gord Dibben]

Max

Did you first sort the data by using the sort macro found on sheet "List"?


Gord

 

[Max]

Did you first sort the data by using the sort macro found on sheet "List"?
Aha! No, I din't (sheepish). Jumped right into the pool w/o going to the
changing room!
Thanks, it works fine.

---

 

[le clef]

Hello all

My thanks to all for the knowledge you give to the questions asked - but
most of all a thank you for the time you dedicate to answer these questions.

My thanks once again.

Nigel.