GreenTree
06-27-2007, 12:42 PM
Let's say I have a user form with ten text boxes on it. I'd like to be able to specify which one I put a value in with a variable, so that if N = 1, I'm dealing with .textbox1.value, if N=2 then .textbox2.value, etc. Is there an easy way to do that? (Perfectly happy to name the boxes whatever they'd need to make such a scheme work.)
Followup question, suppose I have the textboxes in rows and columns in the user form; can I name them in such a way that when R = 12 and C = 2 I'm dealing with with .textboxR12C2.value? (If not, I can do something equivalent with a solution to the first question above, but if this is easy, why do an unnecessary workaround?)
Thanks!
G.T.
Followup question, suppose I have the textboxes in rows and columns in the user form; can I name them in such a way that when R = 12 and C = 2 I'm dealing with with .textboxR12C2.value? (If not, I can do something equivalent with a solution to the first question above, but if this is easy, why do an unnecessary workaround?)
Thanks!
G.T.