When I use the For Loop to assign the values to the respective controls (like
labels, textbox etc), how can we increment / decrement the control names. For
instance:
for i = 1 to 100
userform1.label1.text = cells(i,1)
userform1.textbox10.text = cells(i,2)
userform1.textbox11.text = cells(i,3)
next i
In the above statement it will be assigned only in label1, textbox10, textbox11,
when I is going to be incremented from 1 to 2 the values of hte controls like
label2, textbox20, textbox21 should be assigned.
Could you please help  me on the same.