Kenw
09-16-2015, 12:50 PM
I have a matrix of 4 x 3 combo boxes on a form and wish to perform the same action on each of the 12 (ie make visible, set font, set list index get input etc etc etc) Do I have to write routines specific to each control or can I build up commands by stringing the various parts of the box address into a variable and obeying that variable.
I have tried the latter but it doesn't seem to work (eg com = "t"&t&"c"&c&".visible = false" to hide a control - the content of com looks OK but how do I get Excel to perform it.
Any ideas or suggestions would be welcome.
I have tried the latter but it doesn't seem to work (eg com = "t"&t&"c"&c&".visible = false" to hide a control - the content of com looks OK but how do I get Excel to perform it.
Any ideas or suggestions would be welcome.