Hi All I'm working with VBA UserForm, I have inserted 7 textboxes. i would like to control them using array control.
I require to change the height of textbox when it is being focused and back to normal size when losts its focus. For that i wrote coding for each and every textbox by using ENTER and EXIT event. userform name is myform textbox names are txt1, txt2,.....txt7 ?myform.controls(0).name output is txt1 ?myform.controls(1).name output is txt2 ...... ..... .... ..... ..... ?myform.controls(6).name output is txt7 by seeing above output i got a doubt that instead of writing code to each and every textbox cant we use common code by changing only index. Is there any other way to perform the same action in single code using for loop or something else? Thanks in advance Ismail Ali
