Home > database >  how to check the box automatically when two cell values are checked
how to check the box automatically when two cell values are checked

Time:04-14

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.

  • Related