Thank you for your reply, Roy-Vidar. But I don't understand how that was going to help me. What does this line do?:
debug.print me.controls("TB" & cstr(lngCounter)).value
I tried to set the Visible-property of TB1 to TB5 as True, but it didn't work.
Dim lngCounter As Long
For lngCounter = 1...
I would like to make references to an unknown number (max 10) of textboxes. The name of the textboxes are "myTB1", "myTB2", "myTB3" and so on.
I know that I cold have used
**********
Dim ref1
Set ref1 = UserForm1.myTB1
Dim ref2
Set ref2 = UserForm1.myTB2
**********
... and so on...
I hva tried...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.