Deselecting A CheckBox Automatically

**heliskier89** · 06-14-2011, 01:55 PM

I’m using this code to achieve the following;
If the box is checked then a message box asks a question.
If the answer is YES then the current date and users name is entered into cells E3 and F3.
If the answer is NO then another message box appears with an instruction.
Click Okay and any contents in cells E3 and F3 are cleared.

However, I also want to remove the tick from the Check Box if the answer is NO.
How can this be achieved as well?

Please Login or Register  to view this content.

**mrice** · 06-14-2011, 02:20 PM

Please Login or Register  to view this content.

??

**111StepsAhead** · 06-14-2011, 02:21 PM

Try this.

Please Login or Register  to view this content.

**davegugg** · 06-14-2011, 02:23 PM

Please Login or Register  to view this content.

**davegugg** · 06-14-2011, 02:24 PM

Oops, a dismal third.

**heliskier89** · 06-16-2011, 11:47 AM

Tried this code but it doesn't clear the checkbox!

ActiveSheet.CheckBoxes(Application.Caller).Value = 0

Will this line just look at the checkbox contents but not change them?

**Leith Ross** · 06-17-2011, 01:38 AM

Hello heliskier89,

The Forms style Check Boxes use the Excel constant xlOff instead of zero to indicate a False condition. ActiveX Check boxes use zero for false. This will work...

Please Login or Register  to view this content.

**heliskier89** · 06-17-2011, 01:34 PM

Please Login or Register  to view this content.

Thanks, that works great. However, it has thrown up another little quirk!
If cells E3 and F3 have the name and date already inserted and you choose to deselect this by removing the tick from the checkbox, the tick is removed from the checkbox but the contents of E3 and F3 remain.
Any ideas on how to fix this?

**tigeravatar** · 06-17-2011, 01:46 PM

heliskier89,

Give this a try:

Please Login or Register  to view this content.

**heliskier89** · 06-17-2011, 02:22 PM

Excellent. Thanks very much for the parting of your knowledge on a humble beginner. I'm very grateful and love when I can follow the code so as I don't have to bother you guys as much.

Many Thanks