braindiesel
Well-known Member
- Joined
- Mar 16, 2009
- Messages
- 571
- Office Version
- 365
- 2019
- 2010
- Platform
- Windows
I have a userform with a couple listboxes... the second is enabled for multiselect.
When I click 2 or more items and it gets to this code, it does what I want it to do for the first one... but it "forgets" or deselects the rest of the selections...
Any suggestions?
When I click 2 or more items and it gets to this code, it does what I want it to do for the first one... but it "forgets" or deselects the rest of the selections...
Any suggestions?
VBA Code:
For i = 0 To ListBox2.ListCount - 1
If ListBox2.Selected(i) = True Then
guts.Select
putItHere = guts.Range("daClients").Offset(i + 1, 1).Value
backStage.Select
backStage.Cells(putItHere, Range("dataList[[#Headers],[Action]]").Column).Value = "X"
End If
'If ListBox1.Selected(i) = False Then guts.Range("daFirms").Offset(i + 1, 1).Value = ""
Next i