Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default drop down data want to choose more than one item for cell

I have a drop down box that i want folks to be able to choose more than one
item from the box to go into the cell.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default drop down data want to choose more than one item for cell

Multiselect from a DV dropdown is possible using VBA.

See Debra Dalgleish's site for a downloadable sample workbook with event
code.

http://www.contextures.on.ca/excelfiles.html#DV0017

Note that you can have the selections in an adjacent cell or in the same
cell.


Gord Dibben MS Excel MVP

On Fri, 26 Feb 2010 12:40:08 -0800, FranW
wrote:

I have a drop down box that i want folks to be able to choose more than one
item from the box to go into the cell.


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
Making a drop down control to choose a data series WallyWallWhackr Charts and Charting in Excel 0 June 30th 09 08:22 AM
Populating Data From Drop-Down Item MR Excel Worksheet Functions 1 June 16th 09 03:14 AM
How can I choose more than one item from list in a form in Excel? Jolly Excel Worksheet Functions 7 July 14th 08 06:28 PM
Choose from drop down menu and get defined output in another cell NWCrane Excel Discussion (Misc queries) 4 July 4th 07 12:04 PM
Can I choose more than one item in the page field area? trainer07 Excel Discussion (Misc queries) 1 April 19th 07 10:22 AM


All times are GMT +1. The time now is 01:31 PM.

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"