web 2.0


Uncheck various checkboxes on a worksheet using VBA

Suppose you have a form in Excel with various checkboxes. After they have been checked you need an easy way to encheck them all.

This example shows you how:

Sub UnCheck()
    Dim chkBox        As Object
   
    For Each chkBox In ThisWorkbook.Sheets("Place_Your_Worksheet_Name_Here").CheckBoxes
        chkBox.Value = False
    Next chkBox
   
End Sub

Tags: , , ,

Microsoft Excel | Microsoft Excel - VBA

Comments

Comments are closed