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.

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

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

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

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

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

le clef wrote:
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
Contextures
http://www.contextures.com/tiptech.html

Debra,

'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?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Max

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


Gord

On Wed, 27 Feb 2008 09:19:03 +0800, "Max" wrote:

Debra,

'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?

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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.

"le clef" wrote:

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.