Greetings,
I know that I can range worksheet cell references in userform, but can I range the textboxes in that same userform?
Instead of doing this for 40 text boxes
I would rather do something like this:
Not sure how to tweak this, the semicolon is not the correct syntax -appreciate any input - thanks
I know that I can range worksheet cell references in userform, but can I range the textboxes in that same userform?
Instead of doing this for 40 text boxes
Code:
TextBox1 = ""
TextBox2 = ""
TextBox3 = ""
TextBox4 = ""
TextBox5 = ""
TextBox6 = ""
TextBox7 = ""
TextBox8 = ""
TextBox9 = ""
TextBox10 = ""
TextBox11 = ""
'all the way up to 40+ text boxes...
I would rather do something like this:
Code:
Range("TextBox1:textbox40") = ""
Not sure how to tweak this, the semicolon is not the correct syntax -appreciate any input - thanks