LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Data validation function and drop-down lists

Thank you for your help.
Colleen

Roger Govier wrote:
Hi Colleen

As Tom rightly says, there isn't.
However there are a few "tricks" to achieve this if you take a look at
Debra Dalgleish's site
http://www.contextures.com/xlDataVal08.html#Larger
http://www.contextures.com/xlDataVal08.html#Wider

or by adding a Combo Box to the sheet
http://www.contextures.com/xlDataVal10.html


 
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
Data Validation & Drop-Down Lists fly61265 Excel Discussion (Misc queries) 4 June 3rd 09 04:12 PM
data validation and drop down lists LewR Excel Discussion (Misc queries) 3 March 14th 06 06:50 PM
data validation - Drop Down Lists Annie Excel Discussion (Misc queries) 8 July 29th 05 01:03 AM
Data Validation - Drop down lists - if then? Steve R Excel Discussion (Misc queries) 2 April 8th 05 06:13 PM
Data Validation Lists - drop down. Sameer[_5_] Excel Programming 5 August 16th 04 10:45 PM


All times are GMT +1. The time now is 02:28 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"