depending upon the crontol you are using (if dropdown or listboxes the
selcted item is 0 based)
Else
if you have named the contol its just
controlname.value

So it would be something like
For i = 1 to controlname.value
would let to loop until the value +1 stored in controlname was reached.





wrote in message
oups.com...
Hi Tom.
This is ok.. But my case is different.
I am working out this partiuclar bit in between some other works
through loops..

I am calling a loop from say 1 to 100 and it will do many other
validations and scoring in each time and after that it will display
some details of the row like name , number etc from the sheet and asks
for this answers.. so if i use the loop and way of adding, how can i
get the aorrect answers of each row into the sheet..

You got me.??
when i use the

userform1.show
the value of the 'i' for loop may be 10 ( lets say like that) , so it
should add the value to the 10th column.

I added a button on the screen to add it, but how can i get that value
of 'i' in the form .

thanks