Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 460
Default Drop Down box

How can I make a drop down box in a cell so to choose either of 3 selections?
Does this require a macro or can it be done without?
--
Thank you!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 464
Default Drop Down box

Data Validation with List Option and in the source, either reference a range
or type: Item1,Item2,Item3

http://www.ozgrid.com/Excel/data-validation.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Doug" wrote in message
...
How can I make a drop down box in a cell so to choose either of 3
selections?
Does this require a macro or can it be done without?
--
Thank you!


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
How to create 2 dependent drop down lists from 1 original drop dow Caroline Excel Discussion (Misc queries) 5 May 1st 09 02:19 PM
Drop down lists that auto create and then filter the next drop down list [email protected] Excel Worksheet Functions 2 September 30th 07 11:53 AM
how do I link a drop down list entry to a new drop down cell? lmunzen Excel Discussion (Misc queries) 1 August 15th 06 04:59 PM
controlling a form drop down based on selection of another drop down flurry[_7_] Excel Programming 1 June 5th 06 04:31 PM
Cross-referenced drop-down menu (nested drop-downs?) creativeops Excel Worksheet Functions 4 November 22nd 05 05:41 PM


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