data validation list box help
 

When I click on the drop down curser to pull up my list, the scroll bar is
about middle ways on the bar and does not show my list, i have to take my
mouse and scroll up to the beginning of list.

How can i have the list to show correctly???

data validation list box help
 

I think what you are seeing is the DV automatically position the list with
the last selected item.

--
__________________________________
HTH

Bob

"LTOSH" wrote in message
...
When I click on the drop down curser to pull up my list, the scroll bar is
about middle ways on the bar and does not show my list, i have to take my
mouse and scroll up to the beginning of list.

How can i have the list to show correctly???

data validation list box help
 

ok and???????? i appreciate that info but how do i fix it??

"Bob Phillips" wrote:

I think what you are seeing is the DV automatically position the list with
the last selected item.

--
__________________________________
HTH

Bob

"LTOSH" wrote in message
...
When I click on the drop down curser to pull up my list, the scroll bar is
about middle ways on the bar and does not show my list, i have to take my
mouse and scroll up to the beginning of list.

How can i have the list to show correctly???

data validation list box help
 

The only way I can see is to clear the value out first.

--
__________________________________
HTH

Bob

"LTOSH" wrote in message
...
ok and???????? i appreciate that info but how do i fix it??

"Bob Phillips" wrote:

I think what you are seeing is the DV automatically position the list
with
the last selected item.

--
__________________________________
HTH

Bob

"LTOSH" wrote in message
...
When I click on the drop down curser to pull up my list, the scroll bar
is
about middle ways on the bar and does not show my list, i have to take
my
mouse and scroll up to the beginning of list.

How can i have the list to show correctly???

data validation list box help
 

Remove the blank cells from the bottom of the list range.


Gord Dibben MS Excel MVP

On Tue, 15 Sep 2009 12:06:02 -0700, LTOSH
wrote:

When I click on the drop down curser to pull up my list, the scroll bar is
about middle ways on the bar and does not show my list, i have to take my
mouse and scroll up to the beginning of list.

How can i have the list to show correctly???

data validation list box help
 

i have multiple columns that do the same thing, so you are telling me i have
delete all the info in all my columns and start over???

"Bob Phillips" wrote:

The only way I can see is to clear the value out first.

--
__________________________________
HTH

Bob

"LTOSH" wrote in message
...
ok and???????? i appreciate that info but how do i fix it??

"Bob Phillips" wrote:

I think what you are seeing is the DV automatically position the list
with
the last selected item.

--
__________________________________
HTH

Bob

"LTOSH" wrote in message
...
When I click on the drop down curser to pull up my list, the scroll bar
is
about middle ways on the bar and does not show my list, i have to take
my
mouse and scroll up to the beginning of list.

How can i have the list to show correctly???

data validation list box help
 

I'm sorry...i guess i'm not understanding what i need to do.
I opened the worksheet that has all the columns and am not sure what it is
i'm to delete. For example...i have column 1 and there are about 10 cells of
information.
then of course blank cells after that for input if needed. I went in and
highlighted from the first blank cell and just pulled mouse down and then hit
delete.
i went back into my workout to test the drop down and it is still the same.

What am i not doing?
I'm sorry i'm nuts...just can't figure it out.
Thanks!

"Gord Dibben" wrote:

Remove the blank cells from the bottom of the list range.


Gord Dibben MS Excel MVP

On Tue, 15 Sep 2009 12:06:02 -0700, LTOSH
wrote:

When I click on the drop down curser to pull up my list, the scroll bar is
about middle ways on the bar and does not show my list, i have to take my
mouse and scroll up to the beginning of list.

How can i have the list to show correctly???

data validation list box help
 

In Data ValidationAllowList you have a source for your list.

Assume you have selected a range like =A1:A20

If there are blank cells at the end of the list range.............say
A15:A20, your list will open at the first blank cell.

Remove those cells from your list range.

Make it A1:A14


Gord

On Tue, 15 Sep 2009 16:28:01 -0700, LTOSH
wrote:

I'm sorry...i guess i'm not understanding what i need to do.
I opened the worksheet that has all the columns and am not sure what it is
i'm to delete. For example...i have column 1 and there are about 10 cells of
information.
then of course blank cells after that for input if needed. I went in and
highlighted from the first blank cell and just pulled mouse down and then hit
delete.
i went back into my workout to test the drop down and it is still the same.

What am i not doing?
I'm sorry i'm nuts...just can't figure it out.
Thanks!

"Gord Dibben" wrote:

Remove the blank cells from the bottom of the list range.


Gord Dibben MS Excel MVP

On Tue, 15 Sep 2009 12:06:02 -0700, LTOSH
wrote:

When I click on the drop down curser to pull up my list, the scroll bar is
about middle ways on the bar and does not show my list, i have to take my
mouse and scroll up to the beginning of list.

How can i have the list to show correctly???

data validation list box help
 

I looked at the information you provided....here is what I have under my Data
Validation...List..then under souce is =Categories.
The 'categories' is from a worksheet named 'exercises'.
It does not have a list range as you described.

The second column on my workout sheet i have a data validation and the
information under source is =indirect(a5)...which refers to the information i
was describing at the top.

Anythoughts?

"Gord Dibben" wrote:

In Data ValidationAllowList you have a source for your list.

Assume you have selected a range like =A1:A20

If there are blank cells at the end of the list range.............say
A15:A20, your list will open at the first blank cell.

Remove those cells from your list range.

Make it A1:A14


Gord

On Tue, 15 Sep 2009 16:28:01 -0700, LTOSH
wrote:

I'm sorry...i guess i'm not understanding what i need to do.
I opened the worksheet that has all the columns and am not sure what it is
i'm to delete. For example...i have column 1 and there are about 10 cells of
information.
then of course blank cells after that for input if needed. I went in and
highlighted from the first blank cell and just pulled mouse down and then hit
delete.
i went back into my workout to test the drop down and it is still the same.

What am i not doing?
I'm sorry i'm nuts...just can't figure it out.
Thanks!

"Gord Dibben" wrote:

Remove the blank cells from the bottom of the list range.


Gord Dibben MS Excel MVP

On Tue, 15 Sep 2009 12:06:02 -0700, LTOSH
wrote:

When I click on the drop down curser to pull up my list, the scroll bar is
about middle ways on the bar and does not show my list, i have to take my
mouse and scroll up to the beginning of list.

How can i have the list to show correctly???

data validation list box help
 

Categories would be a named range from worksheet "Exercises"

Have a look under InsertNameDefine.

What range does Categories refer to?


Gord

On Wed, 16 Sep 2009 19:25:02 -0700, LTOSH
wrote:

I looked at the information you provided....here is what I have under my Data
Validation...List..then under souce is =Categories.
The 'categories' is from a worksheet named 'exercises'.
It does not have a list range as you described.

The second column on my workout sheet i have a data validation and the
information under source is =indirect(a5)...which refers to the information i
was describing at the top.

Anythoughts?

"Gord Dibben" wrote:

In Data ValidationAllowList you have a source for your list.

Assume you have selected a range like =A1:A20

If there are blank cells at the end of the list range.............say
A15:A20, your list will open at the first blank cell.

Remove those cells from your list range.

Make it A1:A14


Gord

On Tue, 15 Sep 2009 16:28:01 -0700, LTOSH
wrote:

I'm sorry...i guess i'm not understanding what i need to do.
I opened the worksheet that has all the columns and am not sure what it is
i'm to delete. For example...i have column 1 and there are about 10 cells of
information.
then of course blank cells after that for input if needed. I went in and
highlighted from the first blank cell and just pulled mouse down and then hit
delete.
i went back into my workout to test the drop down and it is still the same.

What am i not doing?
I'm sorry i'm nuts...just can't figure it out.
Thanks!

"Gord Dibben" wrote:

Remove the blank cells from the bottom of the list range.


Gord Dibben MS Excel MVP

On Tue, 15 Sep 2009 12:06:02 -0700, LTOSH
wrote:

When I click on the drop down curser to pull up my list, the scroll bar is
about middle ways on the bar and does not show my list, i have to take my
mouse and scroll up to the beginning of list.

How can i have the list to show correctly???

data validation list box help
 

Yes...'Categories' is a named range from the worksheet "exercises"
it has a list of the following...Abs, Chest, Cardio, Shoulders ...etc

"Gord Dibben" wrote:

Categories would be a named range from worksheet "Exercises"

Have a look under InsertNameDefine.

What range does Categories refer to?


Gord

On Wed, 16 Sep 2009 19:25:02 -0700, LTOSH
wrote:

I looked at the information you provided....here is what I have under my Data
Validation...List..then under souce is =Categories.
The 'categories' is from a worksheet named 'exercises'.
It does not have a list range as you described.

The second column on my workout sheet i have a data validation and the
information under source is =indirect(a5)...which refers to the information i
was describing at the top.

Anythoughts?

"Gord Dibben" wrote:

In Data ValidationAllowList you have a source for your list.

Assume you have selected a range like =A1:A20

If there are blank cells at the end of the list range.............say
A15:A20, your list will open at the first blank cell.

Remove those cells from your list range.

Make it A1:A14


Gord

On Tue, 15 Sep 2009 16:28:01 -0700, LTOSH
wrote:

I'm sorry...i guess i'm not understanding what i need to do.
I opened the worksheet that has all the columns and am not sure what it is
i'm to delete. For example...i have column 1 and there are about 10 cells of
information.
then of course blank cells after that for input if needed. I went in and
highlighted from the first blank cell and just pulled mouse down and then hit
delete.
i went back into my workout to test the drop down and it is still the same.

What am i not doing?
I'm sorry i'm nuts...just can't figure it out.
Thanks!

"Gord Dibben" wrote:

Remove the blank cells from the bottom of the list range.


Gord Dibben MS Excel MVP

On Tue, 15 Sep 2009 12:06:02 -0700, LTOSH
wrote:

When I click on the drop down curser to pull up my list, the scroll bar is
about middle ways on the bar and does not show my list, i have to take my
mouse and scroll up to the beginning of list.

How can i have the list to show correctly???

data validation list box help
 

I don't understand your reply.

In the refer to: dialog box what do you see when you select the name
"Categories"

Can you copy and paste it here?


Gord Dibben MS Excel MVP

On Thu, 17 Sep 2009 11:58:11 -0700, LTOSH
wrote:

Yes...'Categories' is a named range from the worksheet "exercises"
it has a list of the following...Abs, Chest, Cardio, Shoulders ...etc

"Gord Dibben" wrote:

Categories would be a named range from worksheet "Exercises"

Have a look under InsertNameDefine.

What range does Categories refer to?


Gord

On Wed, 16 Sep 2009 19:25:02 -0700, LTOSH
wrote:

I looked at the information you provided....here is what I have under my Data
Validation...List..then under souce is =Categories.
The 'categories' is from a worksheet named 'exercises'.
It does not have a list range as you described.

The second column on my workout sheet i have a data validation and the
information under source is =indirect(a5)...which refers to the information i
was describing at the top.

Anythoughts?

"Gord Dibben" wrote:

In Data ValidationAllowList you have a source for your list.

Assume you have selected a range like =A1:A20

If there are blank cells at the end of the list range.............say
A15:A20, your list will open at the first blank cell.

Remove those cells from your list range.

Make it A1:A14


Gord

On Tue, 15 Sep 2009 16:28:01 -0700, LTOSH
wrote:

I'm sorry...i guess i'm not understanding what i need to do.
I opened the worksheet that has all the columns and am not sure what it is
i'm to delete. For example...i have column 1 and there are about 10 cells of
information.
then of course blank cells after that for input if needed. I went in and
highlighted from the first blank cell and just pulled mouse down and then hit
delete.
i went back into my workout to test the drop down and it is still the same.

What am i not doing?
I'm sorry i'm nuts...just can't figure it out.
Thanks!

"Gord Dibben" wrote:

Remove the blank cells from the bottom of the list range.


Gord Dibben MS Excel MVP

On Tue, 15 Sep 2009 12:06:02 -0700, LTOSH
wrote:

When I click on the drop down curser to pull up my list, the scroll bar is
about middle ways on the bar and does not show my list, i have to take my
mouse and scroll up to the beginning of list.

How can i have the list to show correctly???