mardi 8 février 2022

Auto Select Checkbox triggered by another checkbox

I am trying to auto select a checkbox if any another checkbox is selected. All this checkboxes are on the same sheet and basically i want check box 7 to tick if checkbox 3,4 or 5 is selected.

Private Sub Worksheet_Change(ByVal Target As Range)

If Sheets("Start Page").CheckBox3 = True Or Sheets("Start Page").CheckBox4 = True Or 
Sheets("Start Page").CheckBox5 = True Then
Sheets("Start Page").CheckBox7 = True
Else
End If

End Sub

Any help would be greatly appreciated.




Aucun commentaire:

Enregistrer un commentaire