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.


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

Report •

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.

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

Report •
Related Solutions

Ask Question