I have the following in my userform:
CheckBox11 CheckBox12 CheckBox13 CheckBox14 CheckBox15 CheckBox21 CheckBox22 CheckBox23 CheckBox24 CheckBox25
Also, in my excel i have following named ranges
range11 range12 range13 range14 range15 range21 range22 range23 range24 range25
i want to loop through each of the checkbox, and in case of True, do something with the range, Say copy paste the corresponding ranges to another location.
I have a nested For loop, i = 1 to 2 and j = 1 to 5
and then inside another long variable nm = i*10+j
now i want to refer to the CheckBox and Range with nm.
Any other alternative is also welcome.
Thanks in Advance.
Aucun commentaire:
Enregistrer un commentaire