Message when cell changes

[darkblueblood]

I have the following code in my worksheet_calculate sub, and another sub:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

it's a bit of a complicated sheet here checkboxes are ticked, and when 3 in a certain area are ticked, then a cell value changes (AC6)

This works very well, and the message is displayed.

Any ideas how I would adapt this to include other cells? The cells I'd want to include are AC6, AC9, AC12, AC15, AC18, AC21, AC24.

Thanks in advance

[stnkynts]

Try changing this line:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

[Kaper]

At first sight - have you tried just:

Please Login or Register  to view this content.

etc

[darkblueblood]

Try changing this line:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

Not sure if I changed the correct part, or not, but it didn't seem to work. I've sent a pm with a link to the spreadsheet I'm using and more details if that will help

[darkblueblood]

At first sight - have you tried just:

Please Login or Register  to view this content.

etc

That seems to work perfectly. Thanks for your help