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 one) to select/deselect all the five option by the same time.

I was hoping to do it without using VBA.

Thanks in advance

 

Eugenio

excel
Formulas and Functions
Macros and VBA

2 Replies

  • 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