If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Validation blues
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 |
#3
|
|||
|
|||
Validation blues
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 |
#4
|
|||
|
|||
Validation blues
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 |
#5
|
|||
|
|||
Validation blues
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 |
#6
|
|||
|
|||
Validation blues
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 |
Thread Tools | |
Display Modes | |
|
|