i have multiple text boxes on my userform. i would like to get the values of each using a for loop. the text boxes are named txtBox1, txtBox2,...
i would like to do something like this:
For i = 1 to 10
Print ("txtBox" & i).value ' trying to print value of txtBox1
Next i
can someone point me in the right direction? thanks in advance.