Code not running properly! Getting error message

[mwolfe571]

I am trying to make a multi value picklist so when a user selects more than one option from the drop down menu, the results show in one cell separated by commas. I found this code online and plugged it into VB on my spreadsheet and it's not working. I'm not a coding expert so I don't know what the solution is. See code below:

Please Login or Register  to view this content.

[arlu1201]

Remove this line from your code -

Please Login or Register  to view this content.

. This is line 1 and remove the End Sub at the end. You need to have only 1 End Sub.

[mwolfe571]

Now VB is not recognizing my macro since I took out the first line.

[arlu1201]

Once you remove the top line, what you get is a worksheet event macro. Hence you need to select on your sheet containing the data, right click and select "View Code" and then copy the code in there. As soon as you change the dropdown values, the macro will start working as desired.

[mwolfe571]

Thank you! I got it to work!

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.