ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Validation List - Reset to Top Value? (https://www.excelbanter.com/excel-programming/373941-validation-list-reset-top-value.html)

Dan von InfoPath

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.

Dan von InfoPath

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.



All times are GMT +1. The time now is 07:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com