LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
Grd Grd is offline
external usenet poster
 
Posts: 118
Default pick multiple items in data validation


Great
will have a look
tx

"Gord Dibben" wrote:

See Debra Dalgleish's site for a sample workbook.

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

DV0017 - Select Multiple Items from Dropdown List-- Select multiple items
from a
dropdown list; an event macro stores selections in adjacent cell, or in same
cell. DataValMultiSelect.zip 18kb updated 22-Feb-07


Gord Dibben MS Excel MVP

On Thu, 18 Mar 2010 07:48:01 -0700, Grd
wrote:

Hi,

I'd like to pick two items from the picklist. I'm using data validation with
the list option pointing to a range of cells and so far it seems I can only
pick one from the list.

Anyway I get to pick two items or is there something else I can use?

Any help would be greatly appreciated.

Tx

Grd


.

 
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
Data Validation-pick from dropdown and next cell auto fills in inf sunsetsweete Excel Worksheet Functions 1 July 16th 09 07:06 PM
Data validation - 2 items Mike Excel Discussion (Misc queries) 0 April 21st 09 08:54 PM
pick list and Data Validation Makelei Excel Discussion (Misc queries) 2 December 4th 08 05:06 AM
Data-Validation -List - Pick from a drop down menu kay Excel Discussion (Misc queries) 4 July 8th 08 09:06 PM
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM


All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"