Excel 2003; I have a dropdown box populated from a list of about 100 items.
When the user selects the dropdown box to choose an item I want the first row
in
the list to be displayed on top (with the scroll bar all the way at the
top); currently the last row is displayed (and it's blank).

I cannot figure out why this is happening or what to do about it.

Thanks,
Steve

If using Data Validation List, re-define the range to get rid of the blanks at
bottom of the list.

Maybe a dynamic range would be better.

See Debra Dalgleish's site for this.

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


Gord Dibben MS Excel MVP

On Tue, 12 Jun 2007 12:27:03 -0700, stebro
wrote:

Excel 2003; I have a dropdown box populated from a list of about 100 items.
When the user selects the dropdown box to choose an item I want the first row
in
the list to be displayed on top (with the scroll bar all the way at the
top); currently the last row is displayed (and it's blank).

I cannot figure out why this is happening or what to do about it.

Thanks,
Steve

Are you using Data Validation for this drop down?

Just eliminate the blank cell from the end of the list.

If you *want* a blank cell in the list to enable user input beyond the list,
make the *first* cell in the list blank.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"stebro" wrote in message
...
Excel 2003; I have a dropdown box populated from a list of about 100
items.
When the user selects the dropdown box to choose an item I want the first
row
in
the list to be displayed on top (with the scroll bar all the way at the
top); currently the last row is displayed (and it's blank).

I cannot figure out why this is happening or what to do about it.

Thanks,
Steve

Thanks to you both for your assistance. I followed the instructions for
creating a dynamic list but it didn't work because the list is actually a
part of a pre-defined array. Excel recognizes all of the rows in the array
as being a part of the list.

Also, the problem is not the blank row really. While I would prefer not to
have the blank row I wouldn't really care if it appeared at the bottom of the
list, as long as the dropdown list opened up at the top of the list, which is
all I'm trying to do. I don't understand why my list is behaving this way.

Any other suggestions???
Thanks again,
Steve

"Ragdyer" wrote:

Are you using Data Validation for this drop down?

Just eliminate the blank cell from the end of the list.

If you *want* a blank cell in the list to enable user input beyond the list,
make the *first* cell in the list blank.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"stebro" wrote in message
...
Excel 2003; I have a dropdown box populated from a list of about 100
items.
When the user selects the dropdown box to choose an item I want the first
row
in
the list to be displayed on top (with the scroll bar all the way at the
top); currently the last row is displayed (and it's blank).

I cannot figure out why this is happening or what to do about it.

Thanks,
Steve

When you first create the DV dropdown list cell the cell value is blank.

The list will default to the first blank cell at the bottom of the list because
that is the value in the newly created DV cell.

After you have selected any item other than the blank, that item will become the
dropdown default when you click on arrow next time.


Gord

On Tue, 12 Jun 2007 14:44:02 -0700, stebro
wrote:

Thanks to you both for your assistance. I followed the instructions for
creating a dynamic list but it didn't work because the list is actually a
part of a pre-defined array. Excel recognizes all of the rows in the array
as being a part of the list.

Also, the problem is not the blank row really. While I would prefer not to
have the blank row I wouldn't really care if it appeared at the bottom of the
list, as long as the dropdown list opened up at the top of the list, which is
all I'm trying to do. I don't understand why my list is behaving this way.

Any other suggestions???
Thanks again,
Steve

"Ragdyer" wrote:

Are you using Data Validation for this drop down?

Just eliminate the blank cell from the end of the list.

If you *want* a blank cell in the list to enable user input beyond the list,
make the *first* cell in the list blank.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"stebro" wrote in message
...
Excel 2003; I have a dropdown box populated from a list of about 100
items.
When the user selects the dropdown box to choose an item I want the first
row
in
the list to be displayed on top (with the scroll bar all the way at the
top); currently the last row is displayed (and it's blank).

I cannot figure out why this is happening or what to do about it.

Thanks,
Steve