Waterpolo1
New Member
- Joined
- Sep 8, 2015
- Messages
- 21
Context
I can currently search for an ID and populate values in my userform.
I can amend or change values 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. How do I update this box (i,3) ? 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
Many thanks in advance
I can currently search for an ID and populate values in my userform.
I can amend or change values 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. How do I update this box (i,3) ? 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
Many thanks in advance