I'm trying to emulate a user to batch upload information on different records in a database. Basically, I'm changing the values of a listbox on the webpage based on the values in an excel sheet.
So far, I can do one entry at a time, but I can't select more than that within the listbox without holding the control key down. How do I emulate holding the control key down so my loop will run effectively? Here is what I have so far:
With (holding control key down here)
For i = LastRow To 2 Step -1
ID = Range("B" & i)
IE.Document.all("selectedMembers").Value = ID
Next i
End With
If anyone knows of another way of doing this, please let me know.
So far, I can do one entry at a time, but I can't select more than that within the listbox without holding the control key down. How do I emulate holding the control key down so my loop will run effectively? Here is what I have so far:
With (holding control key down here)
For i = LastRow To 2 Step -1
ID = Range("B" & i)
IE.Document.all("selectedMembers").Value = ID
Next i
End With
If anyone knows of another way of doing this, please let me know.
