jeudi 18 juin 2020

Excel VBA: Cycle through Checkboxes by name, and also through similarly named Ranges

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