Objectname(x).value - changeable objectname number

[ag273n]

I'm making a questionnaire of userform in excel 2007, the examinees answers will be tabulated in a hidden sheet. i already got the userform and the tabulating of the answers covered

now...

Is there a way to make an object name change itself in sequence like that of a "for x to Y next function"?

i mean let say i have 140 textboxes - textbox1 up to textbox140
and i wanted to return the values of the textboxes into cells of a row in two different worksheets.


thus:
------------------------------

Please Login or Register  to view this content.

------------------------------
(only 4 textboxes shown)

I'm thinking of using a for-next loop statement to shorten the code instead of doing each textbox from the 140 textboxes for the two worksheets.
How do I do this?
or any better suggestions?


any good suggestion will surely get a star

[OllieB]

Try

Please Login or Register  to view this content.

[JosephP]

if you have used a naming convention like that a simple loop will suffice

Please Login or Register  to view this content.

[ag273n]

both of you gets a star.. its working now and i like it... =)

my pc is not that good so theres a couple of seconds lag on it..

@ joseph, sory man, i didnt know yet how to put code tags. there must be a problem with my browser... i'm not seeing the labels at the quick reply box on the thread... so i went ahead and typed..


thanks =)
and i dont know how to tag this solved..