How do I get a list to default to the first item?

[Guest]

I have a list that has 10 items and 40 blanks for future use. I give the
list a name then I use the Data Validation to call the list from within
another cell. The problem is when I click the dropdown for the list it set
the list to the first blank instead of setting it to the first item. The
scroll bar ends up in the middle and I need it to be located at the top.

 

[Frank Kabel]

Hi
AFAIK you can't change this behaviour

--
Regards
Frank Kabel
Frankfurt, Germany

im Newsbeitrag

I have a list that has 10 items and 40 blanks for future use. I give the
list a name then I use the Data Validation to call the list from within
another cell. The problem is when I click the dropdown for the list it set
the list to the first blank instead of setting it to the first item. The
scroll bar ends up in the middle and I need it to be located at the

top.

 

[Gord Dibben]

Instead of defining the extra 40 blank cells for future use, use a Dynamic
List by defining a Dynamic Range.

Debra Dalgleish has instructions at.......

http://www.contextures.on.ca/xlDataVal08.html#Dynamic

Gord Dibben Excel MVP

On Wed, 27 Oct 2004 11:21:02 -0700, "QTP Professional" <QTP