Validation blues

Hi,

I have created different validations in my worksheet using a list as
dropdown.

Strangely when I click on the cell which has validation then the dropdown
will show the last or the second last while some of the validations window's
dropdown display from first value itself.

That is If i have 1 validation in a cell linked to a list ( Apple, Orange,
Pears, Banana etc.) then the validation dropdown though displays all the
values from the list, it will show Banana first that is drop down window's
highlighting value starts from the mid or may be last.

In another validation list ( having Win2K, Win98, WinXP Etc )the
highlighting value in the dropdown may start with the first value of the
list Win2K highlighted.

I want to know how to configure so that all the validations start with the
first value highlighted.

Regards,
Hari
India

Use an absolute reference to the range that contains the list:

=$A$1:$A$7

or name the range. There are instructions he

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

Hari wrote:
Hi,

I have created different validations in my worksheet using a list as
dropdown.

Strangely when I click on the cell which has validation then the dropdown
will show the last or the second last while some of the validations window's
dropdown display from first value itself.

That is If i have 1 validation in a cell linked to a list ( Apple, Orange,
Pears, Banana etc.) then the validation dropdown though displays all the
values from the list, it will show Banana first that is drop down window's
highlighting value starts from the mid or may be last.

In another validation list ( having Win2K, Win98, WinXP Etc )the
highlighting value in the dropdown may start with the first value of the
list Win2K highlighted.

I want to know how to configure so that all the validations start with the
first value highlighted.

Regards,
Hari
India




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi Debra,

Im sorry for not being clear enough. ( Im using absolute reference only)

The problem is that when I select a cell having validation then the dropdown
window which comes has the scrollbar at the bottom.In this case bottom most
or mid value is getting highlighted

Usually when validation is applied I get the scrollbar at the top, that is
with the topmost value of the list chosen.

To restress the cell on which validation has been done has all the data from
the source list. problem is with the display of the list window.

Regards,
Hari
India


"Debra Dalgleish" wrote in message
...
Use an absolute reference to the range that contains the list:

=$A$1:$A$7

or name the range. There are instructions he

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

Hari wrote:
Hi,

I have created different validations in my worksheet using a list as
dropdown.

Strangely when I click on the cell which has validation then the
dropdown
will show the last or the second last while some of the validations
window's
dropdown display from first value itself.

That is If i have 1 validation in a cell linked to a list ( Apple,
Orange,
Pears, Banana etc.) then the validation dropdown though displays all the
values from the list, it will show Banana first that is drop down
window's
highlighting value starts from the mid or may be last.

In another validation list ( having Win2K, Win98, WinXP Etc )the
highlighting value in the dropdown may start with the first value of the
list Win2K highlighted.

I want to know how to configure so that all the validations start with
the
first value highlighted.

Regards,
Hari
India




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

There is probably a blank cell at the bottom of your list source. When
the dropdown list opens, it matches the cell value to an item in the
list, if one exists.

Delete the blanks from the source, and the problem should disappear. If
you're leaving blanks so the list can grow, you can use a dynamic name
for the range instead. There are instructions on my web site:

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


Hari wrote:
Hi Debra,

Im sorry for not being clear enough. ( Im using absolute reference only)

The problem is that when I select a cell having validation then the dropdown
window which comes has the scrollbar at the bottom.In this case bottom most
or mid value is getting highlighted

Usually when validation is applied I get the scrollbar at the top, that is
with the topmost value of the list chosen.

To restress the cell on which validation has been done has all the data from
the source list. problem is with the display of the list window.

Regards,
Hari
India


"Debra Dalgleish" wrote in message
...

Use an absolute reference to the range that contains the list:

=$A$1:$A$7

or name the range. There are instructions he

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

Hari wrote:

Hi,

I have created different validations in my worksheet using a list as
dropdown.

Strangely when I click on the cell which has validation then the

dropdown

will show the last or the second last while some of the validations

window's

dropdown display from first value itself.

That is If i have 1 validation in a cell linked to a list ( Apple,

Orange,

Pears, Banana etc.) then the validation dropdown though displays all the
values from the list, it will show Banana first that is drop down

window's

highlighting value starts from the mid or may be last.

In another validation list ( having Win2K, Win98, WinXP Etc )the
highlighting value in the dropdown may start with the first value of the
list Win2K highlighted.

I want to know how to configure so that all the validations start with

the

first value highlighted.

Regards,
Hari
India




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi Debra,

U caught the problem by its neck.

Yes I was having blank cells so that the list may grow.

I used ur Offset method.It works like a charm.

Thanx a lot for helping me out.

Regards,
Hari
India



"Debra Dalgleish" wrote in message
...
There is probably a blank cell at the bottom of your list source. When
the dropdown list opens, it matches the cell value to an item in the
list, if one exists.

Delete the blanks from the source, and the problem should disappear. If
you're leaving blanks so the list can grow, you can use a dynamic name
for the range instead. There are instructions on my web site:

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


Hari wrote:
Hi Debra,

Im sorry for not being clear enough. ( Im using absolute reference only)

The problem is that when I select a cell having validation then the
dropdown
window which comes has the scrollbar at the bottom.In this case bottom
most
or mid value is getting highlighted

Usually when validation is applied I get the scrollbar at the top, that
is
with the topmost value of the list chosen.

To restress the cell on which validation has been done has all the data
from
the source list. problem is with the display of the list window.

Regards,
Hari
India


"Debra Dalgleish" wrote in message
...

Use an absolute reference to the range that contains the list:

=$A$1:$A$7

or name the range. There are instructions he

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

Hari wrote:

Hi,

I have created different validations in my worksheet using a list as
dropdown.

Strangely when I click on the cell which has validation then the

dropdown

will show the last or the second last while some of the validations

window's

dropdown display from first value itself.

That is If i have 1 validation in a cell linked to a list ( Apple,

Orange,

Pears, Banana etc.) then the validation dropdown though displays all
the
values from the list, it will show Banana first that is drop down

window's

highlighting value starts from the mid or may be last.

In another validation list ( having Win2K, Win98, WinXP Etc )the
highlighting value in the dropdown may start with the first value of
the
list Win2K highlighted.

I want to know how to configure so that all the validations start with

the

first value highlighted.

Regards,
Hari
India




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

You're welcome. Thanks for letting me know that the Offset method solved
the problem.

Hari wrote:
Hi Debra,

U caught the problem by its neck.

Yes I was having blank cells so that the list may grow.

I used ur Offset method.It works like a charm.

Thanx a lot for helping me out.

Regards,
Hari
India



"Debra Dalgleish" wrote in message
...

There is probably a blank cell at the bottom of your list source. When
the dropdown list opens, it matches the cell value to an item in the
list, if one exists.

Delete the blanks from the source, and the problem should disappear. If
you're leaving blanks so the list can grow, you can use a dynamic name
for the range instead. There are instructions on my web site:

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


Hari wrote:

Hi Debra,

Im sorry for not being clear enough. ( Im using absolute reference only)

The problem is that when I select a cell having validation then the

dropdown

window which comes has the scrollbar at the bottom.In this case bottom

most

or mid value is getting highlighted

Usually when validation is applied I get the scrollbar at the top, that

is

with the topmost value of the list chosen.

To restress the cell on which validation has been done has all the data

from

the source list. problem is with the display of the list window.

Regards,
Hari
India


"Debra Dalgleish" wrote in message
...


Use an absolute reference to the range that contains the list:

=$A$1:$A$7

or name the range. There are instructions he

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

Hari wrote:


Hi,

I have created different validations in my worksheet using a list as
dropdown.

Strangely when I click on the cell which has validation then the

dropdown


will show the last or the second last while some of the validations

window's


dropdown display from first value itself.

That is If i have 1 validation in a cell linked to a list ( Apple,

Orange,


Pears, Banana etc.) then the validation dropdown though displays all

the

values from the list, it will show Banana first that is drop down

window's


highlighting value starts from the mid or may be last.

In another validation list ( having Win2K, Win98, WinXP Etc )the
highlighting value in the dropdown may start with the first value of

the

list Win2K highlighted.

I want to know how to configure so that all the validations start with

the


first value highlighted.

Regards,
Hari
India




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html