View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L2Lafferty L2Lafferty is offline
external usenet poster
 
Posts: 2
Default Data Validation - Drop Down Box

Thank you for the information. I will try and let you know if I am succesful.

Lynn

"Debra Dalgleish" wrote:

You can do this with a data validation dropdown list and programming.
There's an example he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0017 - Select Multiple Items from
Dropdown List'


L2Lafferty wrote:
Can a drop down box be created to allow for multiple selections within the
list.
Example: Sales, Finance, HR, R&D, Purchasing. Can Sales, HR and Purchasing
be selected.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html