Clear / Reset Checkbox on worksheet when userform has a submission

[ipbr21054]

Morning.
I have a worksheet with Checkbox1 & CheckBox2

The user opens the userform & enters a value into TextBox1 etc
The user then uses the commandbutton code to send TextBox1`value to worksheet.
At the same time i would like CheckBox1 & Checkbox2 on the worksheet cleared / reset.

This is work in progress so please advise how the Checkboxes are cleared / Reset so i can then continue

Currently i get compile error variable not defined.

Private Sub SendToInvSheet_Click()
ThisWorkbook.Worksheets("BIKES").Range("A42") = Me.TextBox1.Text
ThisWorkbook.Worksheets("BIKES").Range("R57") = Me.ComboBox1.Text
Unload Me

With Sheets("BIKES")
CheckBox1 = False
CheckBox2 = False
End With
End Sub

 

[Anthony47]

You need to write .CheckBox1 and .CheckBox2 to state that the CheckBoxes are part of the object you specify using "With ..."; thus

With Sheets("BIKES")
    .CheckBox1 = False
    .CheckBox2 = False
End With

See also Using With statements (VBA)

 

[ipbr21054]

Perfect it works Thanks