clear checkmark from checkboxes

[reddcannon]

I have excel 16 and windows 10

I have a button that clears all my data I imput etc and all is fine, however it does not clear the check marks out of the check boxes.

this is what I have for my clear data button
Private Sub CommandButton1_Click()
On Error Resume Next
Range("a1:g40").Value = vbNullString
On Error GoTo 0

End Sub

I don't want to uses another button for the check marks.

 

[Micron]

set their value to false:
CheckboxName = False

You don't need On Error GoTo 0 here, and never at the end of a procedure.

 

[reddcannon]

set their value to false:
CheckboxName = False

You don't need On Error GoTo 0 here, and never at the end of a procedure.

I dont know what you mean by set their value to false and checkboxname = false. Should I be using checkbox from activex controls? because I am using Form controls. Sorry for my ignorance

 

[Micron]

set their value to false and checkboxname = false

There's a colon in what I wrote ( : ) - a separator for ideas or sentence parts.
checkboxname represents the name of your checkbox, which I presume you already have. As far as I know, that should work for either type. If your controls are on a userform, I'd use Me.YourCheckboxNameHere = False