Steve Olsen
asked on
Excel VBA - reference a textbox on a userform using a variable dynamically
On my userform in Excel I have 25 text boxes. How would I dynamically reference one of those text boxes in my VBA code? For example, if each text box is numbered 1 - 25 (textbox1, textbox2, textbox3, etc) is it possible to reference them indirectly using a variable. For example instead of calling me.textbox3,value could I instead reference textbox3 as me.textbox(myVar).value where myVar = 3 ?
Is there a way to dynamically reference an object within userform using VBA?
Is there a way to dynamically reference an object within userform using VBA?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER