VBA / Macro for ListBox?

[traceylreed]

Currently I have figured out how to allow multiple items to be chosen in a list box; however, when I click the "add" button, it doesn't place the information into my spreadsheet. I am assuming it's due to the macro for the "add" button, but I cannot figure this out.

Suggestions?

I have uploaded the spreadsheet for review.

[JosephP]

you have to loop through the items and check which are selected so change the code to

Please Login or Register  to view this content.

[Andy Pope]

If you have a multi selet list you need to go through the Selected array and store the information before writing out.

This will store the codes as a comma seperated list

Please Login or Register  to view this content.

[traceylreed]

Hello JP,

Thank you for this. I tried to use this code but it gave me an error. It gave me a "Syntax Error" and the line "Private Sub cmdADD_Click" was highlighted.

Any ideas on why this would happen?

[traceylreed]

Andy,

This will be useful, thank you.
One question, where do I place this code? Does it matter?

I'm quite new to VBA and I'm learning as I go.

[traceylreed]

OOOHHH! Scratch that! It's working perfectly!!

Thank you so much. I have been scratching my head for days on this!