VBA IF error check that changes colour and displays message

Hi Guys.

I have the below code


This relates to 4 Yes/No boxes.

If the first (H26) is yes then I26 returns a 1

If this is marked yes then the next 3 have to be marked yes or no (They can be left blank if H26 is no).

So the I column returns 0 if its blank and 1 if it has text. I30 sums the 3 columns, which would add up to 3 or less.

If this returns less then 3, I want the Field names to be marked red and a pop up message at the end ( I'd just put mes1, but I'll concatenate all error messages as I have 2-3 fields to check.)

This however is doing absolutely nothing.

Can someone tell me where I've gone wrong?

Please Login or Register  to view this content.

Thanks Alpha,

What a stupid rookie mistake lol. I knew to do range.value but for some reason I didn't!!