Clear a cell when Tick box is ticked

[frank35]

How do I clear Cell B5 only when A tick box is ticked that I created?

[Paul]

I assume you're using a Checkbox control from the ActiveX objects (Developer Ribbon > Controls > Insert > ActiveX). If so, in Design Mode double-click the checkbox to open the code editor for that object and add the following code:

Please Login or Register  to view this content.

Close the VBA Editor and take the checkbox out of Design Mode (on the Developer ribbon).

This will do exactly what you said, even if you unintentionally check the box. If you subsequently un-check it, nothing happens. (e.g. It doesn't undo the previous action.) If the checkbox is already checked, and you un-check it, that will also clear cell B5 since this code simply pertains to the click event. Additional code can be used to determine what to do when the checkbox is checked vs. unchecked, or prompt you for confirmation, etc.

[frank35]

can I simply put that Private Sub into my Sub?

[Paul]

If you already have code for the checkbox in question, sure. Just add the actual line of code (middle), not the Private Sub or End Sub lines.

[frank35]

If I only enter

Please Login or Register  to view this content.

in my sub with other content it will always clear, how do I only clear when that box is ticked?