Check Box wth MsgBox. If Yes then.. If No then..

Hello All,

My understanding of VBA is very basic, so any help concerning this will be much appreciated.

The below script delivers two aims

Step 1) Changes the colour of the allocated cells and adds a user stamp
Step 2) Sends an email depending on whether yes/no is selected.

------------------------------------------------

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
-----------------------------------------------------------------------------------------

When part 1 was successful, i'm failing in delivering part 2.

My aim is, when yes or no is selected an email is generated, this email will be set to .Display so if any editing is required it can be done before the email is sent.

The text in Red is where the error begins, however i'm unable to overcome the problem.


Please can anyone help?

Thank you in advance.

Kind Regards.

The text in Red is where the error begins, however i'm unable to overcome the problem.

Always describe error messages and behavior when you say there is a problem.

I see a few problems.

There are no variables Yes or No declared or set.

There is no End If to match your final If.

Your code is creating the mail item only if Yes is true. It must always create the mail item, because you send a mail item either way. You can remove the If/End If from around this code.

I think if you fix those things it will work. It worked for me.