Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation List - Reset to Top Value?
Hello,
If you have a blank cell, and put validation on the cell, when you select the dropdown list, it goes to the blank at the bottom of the list. Is there any way force it to go to the top of the list, without selecting the top item? It's really annoying for users to have to scroll up every time they click on a blank cell that has validation on it. This would seem fairly straightforward, but I can't find a property of the ..Validation object to do it. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation List - Reset to Top Value?
Doh, figured it out.
Just placed a space at the top of each named range used in the validation. *slaps himself* Apologies. "Dan von InfoPath" wrote: Hello, If you have a blank cell, and put validation on the cell, when you select the dropdown list, it goes to the blank at the bottom of the list. Is there any way force it to go to the top of the list, without selecting the top item? It's really annoying for users to have to scroll up every time they click on a blank cell that has validation on it. This would seem fairly straightforward, but I can't find a property of the .Validation object to do it. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Macro to reset dependent list | Excel Discussion (Misc queries) | |||
Reset Validation cells to first list value | Excel Discussion (Misc queries) | |||
Using an Excel macro to reset a drop down list | Excel Discussion (Misc queries) | |||
VBA How to Reset a List box | Excel Programming | |||
Validation (Drop down list vs simple text length validation) | Excel Programming |