Waterpolo1
New Member
- Joined
- Sep 8, 2015
- Messages
- 21
Context
I can currently search for an ID and populate values into my userform from an excel sheet.
I can amend or change values in my userform and click an update button and it uploads the new data - code below:
If (TBID1.Text) = ws.Cells(i, 1) Then ' loop to find relevant ID within the data
ws.Cells(i, 1) = TBID1.Text
ws.Cells(i, 2) = ComboBoxCT1.Text
Problem
I have a list box that may have multiple values in my userform. How do I update the corresponding cell (i,3) I want populated in my excel sheet, with all list box values? When I first submitted, I used the following code:
For i = 0 To EvidenceListBox.ListCount - 1
ws.Range("P" & LastRow).Value = ws.Range("P" & LastRow).Value & "|" & EvidenceListBox.List(i)
Next I
But this obviously wont work for an update as the update needs to find the corresponding ID first (as shown from the code above in the text box (TBID1) example.
Thanks for any help!
I can currently search for an ID and populate values into my userform from an excel sheet.
I can amend or change values in my userform and click an update button and it uploads the new data - code below:
If (TBID1.Text) = ws.Cells(i, 1) Then ' loop to find relevant ID within the data
ws.Cells(i, 1) = TBID1.Text
ws.Cells(i, 2) = ComboBoxCT1.Text
Problem
I have a list box that may have multiple values in my userform. How do I update the corresponding cell (i,3) I want populated in my excel sheet, with all list box values? When I first submitted, I used the following code:
For i = 0 To EvidenceListBox.ListCount - 1
ws.Range("P" & LastRow).Value = ws.Range("P" & LastRow).Value & "|" & EvidenceListBox.List(i)
Next I
But this obviously wont work for an update as the update needs to find the corresponding ID first (as shown from the code above in the text box (TBID1) example.
Thanks for any help!