LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 51
Default Drop Down List Format


I have worksheets with a number of drop down lists created with data
validation. I would like the operator to be able to edit these lists, so I
have put in a number of blank cells at the bottom of each list. When the list
is selected the scroll goes to the bottom of the list (blank cells). I have
checked the ignore blank cells box on the validation, but that does not fix
the problem.

Is the a way to get the drop down list scroll to start at the top?

Thanks for your help.

Jim
 
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
I am trying to create a drop down list with format Tasha Excel Discussion (Misc queries) 1 October 29th 09 11:27 AM
data validation drop down list format Pwinkle Excel Worksheet Functions 1 June 23rd 09 08:42 PM
drop down list in .htm format Kevin Excel Programming 0 November 7th 08 05:21 PM
How do I format the Font in an Active X Drop Down List? Daryl - Honeywell Excel Worksheet Functions 0 April 10th 08 03:56 PM
Format Excel Drop Down List Sandy Excel Programming 3 November 11th 06 06:19 AM


All times are GMT +1. The time now is 08:47 AM.

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"