Check Box

[ArbiterWolf]

Hello,

I have a sheet that looks like this.

I would like to create buttons that say "Check All Commercial" "Check All Residential" "Check All RollOff" "Check All" "Uncheck All" and have them actually check mark the coordinating checkmark boxes. How would I go about doing that?

Also it would be nice to have a counter on the bottom counting the check marked boxes.

Can Excel do windowed forms? Im Trying to make something like this for our clients that is user friendly. We want to give them a form to fill out to send back to us showing what they are requesting.

Thank you in advance!!

 

[davesexcel]

attach a link to your sample workbook. Upload the sample to onedrive or similar file sharing place.

 

[ArbiterWolf]

attach a link to your sample workbook. Upload the sample to onedrive or similar file sharing place.

Copy of Escondido Divisions.xlsm

drive.google.com

 

[davesexcel]

Here is the code to turn on Commercial and turn off the others

Sub CommercialChkbx()
    Dim cb As CheckBox, r

    For Each cb In ActiveSheet.CheckBoxes
        r = cb.TopLeftCell.Row
        If Cells(r, "B") = "COMMERCIAL" Then
            cb.Value = xlOn
        Else
            cb.Value = xlOff
        End If
    Next cb

End Sub