Copy Multiple values from Drop list to single cell

March 5, 2012 at 06:55:27
Specs: Windows Vista
Hello all,

I am trying to find a way to have all selected values from a drop list (with multiple values selected) to also displayed/copied in a cell (say A25). This so later on you push a button and the values in cell A25 are copied with other values that were entered in other cells to a new row.
So eventually the sheet will fill up with rows that display some manually entered values and a cell that contains a sting of text (made up from the values that were selected from the dropdown menue).

The list contains names, that i want to be displayed in the A25 cell as text separated by a comma.

Exm. Dave, Partic, Simon
Thank you for your time and effort.

Sebastiaan


See More: Copy Multiple values from Drop list to single cell

Report •


#1
March 5, 2012 at 09:29:20
How are you selecting multiple values from a Drop Down list?

Check out the video at this site then click on the link in the Video Description to download an example spreadsheet that includes the code.

http://www.youtube.com/watch?v=0rH8...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question