Hi guys..
I have an excel sheet and a userform.
When user open the form , they will answer some of the questions like
yes /no in the textboxes, I have to record these answers in the
worksheet.
It should be happend for a loop, like if l give the range 1 to 100, it
should open the form 100times allow to enter the data and store it in
the sheet in the cells ,lets call answer1 to answer 10.
so the cellreference will be like :

Sheets("Mysheet").Range("Answer1 " & i)=userform1.txtanswer1.text

....

How can i do this...

thanks..