Hello!
I'm using the VBA code below to uncheck boxes in my worksheet, and I've assigned it to a shape so when I click it, all checkboxes are unticked.
However, since there are separate sections within the worksheet, I want separate macros that untick checkboxes in different ranges, i.e. one to untick checkboxes in column B, another for column C, etc.
Is this possible?
I
I'm using the VBA code below to uncheck boxes in my worksheet, and I've assigned it to a shape so when I click it, all checkboxes are unticked.
However, since there are separate sections within the worksheet, I want separate macros that untick checkboxes in different ranges, i.e. one to untick checkboxes in column B, another for column C, etc.
Is this possible?
I
VBA Code:
Sub ClearCheckBoxes()
'Updateby Extendoffice
Dim chkBox As Excel.CheckBox
Application.ScreenUpdating = False
For Each chkBox In ActiveSheet.CheckBoxes
chkBox.Value = xlOff
Next chkBox
Application.ScreenUpdating = True
End Sub