Validation blues

H

Hari

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
 
H

Hari

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
 
D

Debra Dalgleish

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
 
H

Hari

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
 
D

Debra Dalgleish

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