Thread: Drop Down box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ozgrid.com ozgrid.com is offline
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!