#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 272
Default drop down box

I have created a worksheet with several drop down boxes. Is there any way the
user can select more than one item in the drop down box ?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,939
Default drop down box

You need to define drop down box. If you mean a list box (not combo box or
data validation) then yes. Now it just depends where you got the list box
from. If it was from the control toolbox then there is a multi select
property (right click the control and select perperties) that you can set. If
it was from the forms toolbar then there is a Format Control - Control -
Selection Type that you can set.
--
HTH...

Jim Thomlinson


"Lori" wrote:

I have created a worksheet with several drop down boxes. Is there any way the
user can select more than one item in the drop down box ?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,979
Default drop down box

You can do that with programming. There's an example he

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

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


Lori wrote:
I have created a worksheet with several drop down boxes. Is there any way the
user can select more than one item in the drop down box ?



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

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
drop down then populate Candyk Excel Discussion (Misc queries) 3 June 4th 06 11:10 PM
Limit drop down list and linking to other info Intuit Excel Worksheet Functions 13 February 2nd 06 09:48 PM
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM
advanced: synchronizing data value across two worksheet drop boxes mdhokie Excel Worksheet Functions 1 October 6th 05 08:46 PM
formulas for drop down menus Char Excel Discussion (Misc queries) 0 July 18th 05 07:29 PM


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