I have two sheets in sheet1 there is a checkbox for Assign grades which i only wanted to be checked automatically if the giving three check boxes (Math physics chemistry) in another sheet2 are checked, if any of the checked box in sheet2 are not checked then I do not check the assign value theses are two separate sheets
CodePudding user response:
With this macro works
Private Sub CHECKBOXES()
If ThisWorkbook.Worksheets(2).CHECKBOXES("Check Box 1").Value = xlOn And ThisWorkbook.Worksheets(2).CHECKBOXES("Check Box 2").Value = xlOn And ThisWorkbook.Worksheets(2).CHECKBOXES("Check Box 3").Value = xlOn Then
ThisWorkbook.Worksheets(1).CHECKBOXES("Check Box 1").Value = xlOn
Else
ThisWorkbook.Worksheets(1).CHECKBOXES("Check Box 1").Value = xlOff
End If
End Sub
Just need to save the macro and run it when you want.