Hi folks. I'm after some help if possible.
I've got a Userform with 200 textboxes on, the name property being
textbox1, textbox2, ..., textbox199, textbox200.
The value properties of the first 8 textboxes are to be written to a
sheet in A1 to H1, the next 8 to row 2 etc etc.
Is there any way I can utilise a loop (for...next or For Each....Next)
when referring to the textboxes to save me the grief of hard coding all
of it? Any tips would be very much appreciated.
All the best,