Hi
I have a code which I am trying to use to uncheck a check box but keep getting the error "Unable to get the CheckBoxes property of Worksheet class"
Can anyone help?
Sub Checkbox_Uncheck()
Dim Response As VbMsgBoxResult
If Range("A1") = True Then
Response = MsgBox("Have you cleared all queries allocated to you?", vbQuestion + vbYesNo)
If Response = vbNo Then
MsgBox "Please clear all queries before you sign off.", vbInformation
Sheets("Sheet1").CheckBoxes("Checkbox1").Value = False
Else
'Call Reload_financials
End If
Else
End If
End Sub
Bookmarks