VBA Needed to Uncheck Boxes

[Oceangirle]

Hello,

This is my first time posting. I am a bit perplexed on how to structure my VBA code to get started, as dealing with a dynamic tab coding issue is new territory for me.

I have a workbook whose sheets are labeled as follows (mm-yy) so the first sheet will be labeled (04-21) and then each month it will be copied and placed before with the tab name being manually updated to the next month (I.e. 05-21 will be a copy of 04-21 with a different sheet name). Once this is done, I would like the VBA code to clear the check boxes on the new sheet, but leave the check boxes as is on the old sheet. Thus , 05-21 should have no boxes checked, but 04-21 should have the same boxes checked as before. Any advice would be helpful for how to begin with the tab issue?

 

[diddi]

hi and welcome to MrExcel
this will clear all checkboxes on your worksheet
call it as follows:

ClearChecks "04-21"

Sub ClearChecks(MyWS As Worksheet)
    Dim cbx As CheckBox

    For Each cbx In MyWS.CheckBoxes
      cbx.Value = False
    Next cbx
End Sub