Multiple data selection from drop down list --> to single cell

**Monami** · 12-08-2014, 03:43 PM

Hi,

need help please

i'm trying to create a drop down list which enables multiple selections,
which those selections will appear in a single cell, separated by commas.

thanks

**PeteABC123** · 12-08-2014, 03:55 PM

Monami My Friend, could you post a sample workbook? Before & after? ??

Pete

**Monami** · 12-09-2014, 06:23 AM

Hi Pete,
i wasn';t able to upload a file - hope the screen shot illustrates my question better

thanks,
M

Capture.PNG

**kvsrinivasamurthy** · 12-09-2014, 08:10 AM

Worksheet_change event is used.Pl see file.
K5 Validated cell, M5 is the destination cell.
If M5 is not having the value of K5, then pnly it will add. This avoids duplication.
code

Please Login or Register  to view this content.

Multiple data selection from drop down list --> to single cell

LinkBack

Thread Tools

Rate This Thread

Display

Multiple data selection from drop down list --> to single cell

Re: Multiple data selection from drop down list --> to single cell

Re: Multiple data selection from drop down list --> to single cell

Re: Multiple data selection from drop down list --> to single cell

Thread Information

Users Browsing this Thread

Similar Threads

Single Cell Value From Either A Drop Down List Or Entered Manually, Depending On Selection

Want to add numbered data into a single drop-down selection

[SOLVED] Returning data across multiple sheets based on drop down list selection

Excel VBA multiple selection drop down data validation list

Populate data in cell based on drop down list selection

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions