Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Macro to reset dependent list Bean Counter[_2_] Excel Discussion (Misc queries) 2 May 12th 10 06:07 PM
Reset Validation cells to first list value FirstVette52 Excel Discussion (Misc queries) 6 February 1st 09 04:57 PM
Using an Excel macro to reset a drop down list BrucenAZ Excel Discussion (Misc queries) 2 November 17th 08 04:06 PM
VBA How to Reset a List box wejofost Excel Programming 2 January 28th 06 04:32 PM
Validation (Drop down list vs simple text length validation) Jason Morin[_2_] Excel Programming 1 April 27th 04 04:56 PM


All times are GMT +1. The time now is 02:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"