Hi,
I have a listbox in a userform enabled to allow the user to make multiple selections.
Based on the user's selection; I want those individual values entered to a range in my sheet.
I have got as far as...(Shamelessly copied from this site)
I have a listbox in a userform enabled to allow the user to make multiple selections.
Based on the user's selection; I want those individual values entered to a range in my sheet.
I have got as far as...(Shamelessly copied from this site)
Code:
For i = 0 To ListBox1.ListCount - 1
If ListBox1.Selected(i) Then
' ** Your code goes here ***
End If
Next i
[CODE]
But what is the code to say X1 = first value, X2 = second value etc..?
Thanks,
Johndinho