Iterating variable questions

[Inti]

Hello all I have this code that is currently not working. I am honestly winging it here. I am pretty new to the language and just took a guess as to how to do this.

I am trying to use a userform to input data into a spreadsheet. This userform has all the fields that the user will need to fill out all at once, hit enter and it gets added to the spreadsheet. The code is pretty simple but I am trying to use a loop to change a variable value which describes the textbox name in the userform.

These are extracts from the full code that can be found in the attachment.

Iters is the is the variable which is iterating from 1 to 9

Please Login or Register  to view this content.

Please Login or Register  to view this content.

as you can see the userform textbox are named

temp1, temp2, temp3 to temp9
run1, run2, run3 to run9

Any ideas why this isn't working? Is this a complete mess or am I unto something? If it's a mess are there any alternate ways to do this?

Any input is appreciated thank you in advance!

[watersev]

hi Inti,

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Inti]

Waterserv, could you please also look into my other thread? http://www.excelforum.com/excel-prog...ml#post3783677

Thank you for your help!