LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 510
Default validation list. Scroll to top when using, how?

Hi

Hard to decide based on such sparse info, but probably your list source
range contains empty cells at bottom. Then when dropdown is activated for
empty cell, the (empty) bottom line of list is selected by default. Use a
dynamic range as list source, to include only non-empty entries into list.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Corey" wrote in message
...
I have some validation lists placed on some cells.
But have noticed that due to the refernced cells being sometimes 10 cells
long, they
alway seem to open looking at the last few cells.
Is there a way to have the list scrolled to the top when clicking the
cell?

--
Regards

Corey



 
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
validation list Crispy Excel Worksheet Functions 1 April 9th 06 06:46 AM
update data validation list with new entries?? cjtj4700 Excel Discussion (Misc queries) 10 December 12th 05 01:00 AM
Dependent List (via Data Validation) Error Dezdan Excel Worksheet Functions 2 December 2nd 05 12:33 AM
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM


All times are GMT +1. The time now is 01:17 PM.

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

About Us

"It's about Microsoft Excel"