If-Else or If-Then-Else - How to perform Either/And?

[Matthew55]

I am struggling with what I think will be simple for an experienced VBA user.

I have a worksheet in which Column A (Print) and Column B (Email) values are "Yes" or "No", and can be of any combination (No/No, No/Yes, Yes/No, or Yes/Yes). If the value of Column A is "Yes", a statement is printed to PDF. If the Value of Column B is "Yes", an email is to be sent. I am looking for guidance on how to structure the macro to address all of the four Yes/No combinations. If-Then? If-Then-Else?

Thank you in advance!

[Keebellah]

You use the following construction:

Please Login or Register  to view this content.

The last Else will take care of any other condition, you can also use ElseIf instead so only if one of the conditions is met something happens.

The other method is using Select Case

Please Login or Register  to view this content.

What you do have to keep in mind is these If or Case statements are case sensitive.

Hope I've been able to push you in the right direction

[Matthew55]

I'll give it a go.

Thank you.