Looping through text boxes
Posted on 2008-10-16
I have a form with 26 text boxes. I'm loading default values into the text boxes from a sheet. Instead of doing something like this:
frmMyForm.tbParam1 = Cells(1,1).Value
frmMyForm.tbParam2 = Cells(1,2).Value
....... up to 26
I'd like to setup a for loop to do the work
For x = 0 to 26
frmMyForm.tbParamx = Cells(1,x).Value
The above code of course doesn't work but that's the idea.
Is there a way to cycle through the text boxes on a form instead of calling out each independently?