I have form object check box's that I wish to control using a dynamic reference. The check box number is in the format "Check Box ?" the "?" is a number from 1 to 21 which happens to reflect the sheet name that it is connected with. The sheets are named with numbers starting with "1" up to "21"
Here is my attempt at the code:
I suspect I may need to re arrange the quotation marks as the basic syntax is is![]()
Dim Box As String Dim Sheet As Sring Box = "Check Box " Sheet = ActiveSheet.Name Sheets("Index").Shapes(Box & Sheet).ControlFormat.Value = True
I need to place this code on all 21 sheets and rather than manually specify the Check Box name on each sheet I'd like the code to incorporate the sheet name in the check box reference if possible..![]()
Sheets("SHEET NAME").Shapes("CHECK BOX NAME").ControlFormat.Value = True
Thanks in advance,
Mick.
Bookmarks