Should be simple but I can't get it correct....
I have a number of textboxes on a userform which I need to loop through and do stuff for each box.
These tend be named in groups such as txtproject1, txtproject2, txtproject3 etc
I have to run similar code on each of these so I'd have the same block of code triplicated - one block for each textbox.
What I'd like to do is address each box by name and counter value, so Me.textbox & 1, Me.textbox & 2 etc but not sure how to address this correctly. - in my head it's something like Me.textbox & (i), so on each pass of the loop, it can address the next box in the sequence.
Can I address them in this way and if so, what's the correct syntax?
Thanks
Bookmarks