changing the controls for a userform
Hi Everyone,
I have a userform which there are too many textboxes something like
500. Depends on the resolution, I need to alter them sometimes even
need to create them all over again.I have to give them a specific Name
to work with my codes.Here is my question, is there any way that I can
change their names automatically with a macro. I know it is not
possible in runtime, but it's so hard to rename those textboxes all
over again whenever I need to alter. Just for your reference those
textbox names goes like
Gm1txt1,Gm1txt2,Gm1txt3,Gm1txt4,.....Gm1txt15 then next column
Gm2txt1,Gm2txt2,Gm2txt3,Gm2txt4,.....Gm2txt15
Gm3txt1,Gm3txt2,Gm3txt3,Gm3txt4,.....Gm3txt15
..
..
Gm38txt1,Gm38txt2,Gm38txt3,Gm38txt4,.....Gm38txt15
Thanks in advance,
Baha
|