Forum Discussion

ebottino_74's avatar
ebottino_74
Copper Contributor
Feb 13, 2020

Check boxes

Hello, is there any way to make one check box being able to control other check boxes? Let's suppose I have a list of five options. I want the user to be able to click on another check box (the 6th...
excel
Formulas and Functions
Macros and VBA
PascalKTeam's avatar
PascalKTeam
Iron Contributor
Feb 19, 2020

Hi ebottino_74 

Bad news: Not possible without VBA

Good news: The code you need is very simple. Is this the behaviour you are looking for?

Attached file contains the VBA code 

 

Code is: 

 

Private Sub CheckBox3_Click()
If CheckBox3 = True Then
CheckBox2 = True
CheckBox1 = True
Else
CheckBox2 = False
CheckBox1 = False
End If

End Sub

 

  • ebottino_74's avatar
    ebottino_74
    Copper Contributor
    Feb 21, 2020

    HiPascalKTeam ,

    thanks for your reply!

    I was hoping it was possible without VBA, but if not I'll use your code!

    Thank you very much

     

    Eugenio

Resources