H
Hambone
Simple problem, no solution yet: I have a UserForm with 50 TexBoxes
named TextBox1, TextBox2 ...TextBox49. I have a row of 50 adjacent
cells who's values need to be loaded into the TextBoxes. Cell one in
the row corresponds to TextBox1 in the UserForm, cell two with TextBox2
and so on.
As it stands, I have to use fifty lines of code to load the values and
then 50 more to store them when the user exits the UserForm. I can't
find a way to index the TextBoxes and load them using a For or While
loop. Presumably then, I could save the changed TextBoxes back to the
sheet using a similar loop. Any ideas?
Thanks in advance,
--Kim
named TextBox1, TextBox2 ...TextBox49. I have a row of 50 adjacent
cells who's values need to be loaded into the TextBoxes. Cell one in
the row corresponds to TextBox1 in the UserForm, cell two with TextBox2
and so on.
As it stands, I have to use fifty lines of code to load the values and
then 50 more to store them when the user exits the UserForm. I can't
find a way to index the TextBoxes and load them using a For or While
loop. Presumably then, I could save the changed TextBoxes back to the
sheet using a similar loop. Any ideas?
Thanks in advance,
--Kim