Listbox Data in UserForm Not Passing to Spreadsheet

Where on which worksheet do you want to write the data selected from the listboxes? Are the listboxes single-select or multi-select?

It would be extremely helpful to see your file, or at least the code you have that already works.

The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

The code to push the data is just:
Sheets("Proposals").Range("Data_Start").Offset(TargetRow, 14).Value = list_PRC

It matches the code to push data for a text box (that does pass the data correctly):
Sheets("Proposals").Range("Data_Start").Offset(TargetRow, 0).Value = txt_ProposalID

I think the issue is the value I'm passing - it should be a string since it's a multi-selection list-box, yes? I'm trying this code to determine the proper string value for the field:

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer


And then the code to pass the data should be this?
Sheets("Proposals").Range("Data_Start").Offset(TargetRow, 14).Value = list_PRCStr

You could put something like this in the Listboxes change event.

Please Login or Register  to view this content.

And later, when writing to the sheet, code like this

Please Login or Register  to view this content.

I do notice that your existing code is using the .Item property of a Listbox. I believe that the .List property is the one you are looking for.

Originally Posted by jd_now

The code to push the data is just:
Sheets("Proposals").Range("Data_Start").Offset(TargetRow, 14).Value = list_PRC

This code uses the list itself, rather than the string you built, which is why it doesn't work. Your code below is the right idea but you will need to declare list_PRCStr in a place where is it visible to both list_PRC_Change (yes, you do want Change instead of Click) and the line of code above.

Please Login or Register  to view this content.

And then the code to pass the data should be this?

Please Login or Register  to view this content.

Yes. Where is this code?

Originally Posted by torachan

Without a desensitised upload of your actual workbook it is unlikely that a solution will happen in the near future.
Your code does not make sense and is unlikely to work no matter what combinations of guesswork are employed.
torachan.

This is a bit pessimistic. The code has a couple of errors but makes perfect sense in light of what the OP has explained that he wants to do.