IsEmpty for multiple cells

Hi,

I'm creating a form which users will complete and email. I need certain mandatory fields to be completed.

I have code which checks if a cell is empty, if it is it prompts a message box and turns the corresponding question cell red. if it is not blank, it will create a pdf and send an email.

This is working however I have several mandatory cells and I'm not sure the best way to write the code to test all mandatory cells before moving on to send the email. if any of them is blank I want to flag the message box and turn any/all blank questions red.

Here is what I have so far:

Please Login or Register  to view this content.

Many thanks in advance!

Brilliant! second time you've sorted me out today Rory!

Only thing is, its not the empty cell I want to turn red but the adjacent cell. eg. if B3 is blank, make A3 red?

Thanks again!

Rorya you're a legend, thank you so much!