Run a message box / macros based on cell value.

[npsnps]

Looking to either create a message box, or run a piece of macros code that contains the message box based on cell value.

Data is in M10.

If the number in there is 17 and below, would like to to run "UNDER" Macros (Which is a message box).

If the number in there is 80 and over, would like to to run "OVER" Macros (Which is a message box).

Could someone help me out?

Thanks

[Mike1001]

That would be an Event macro in the sheet containing the subject M10 cell:

Please Login or Register  to view this content.

[npsnps]

Works a treat, thank you.

[Mike1001]

You're welcome!

[npsnps]

Sorry spoke too soon, the cell with the data (M10) is driven by the below formula to work out age.

Please Login or Register  to view this content.

Any idea how to make it work with this?

[Mike1001]

The following macro will be executed each time the content of cell C12 is changed:

Please Login or Register  to view this content.

However, if there are any other cells that can influence the value of C12, this will not be sufficient.

[Mike1001]

You could either leave the

Please Login or Register  to view this content.

out of the code, but this would trigger a message box each time you Change ANY cell in that sheet and either the OVER or UNDER criteria apply, which can be quite annoying.

In case you know which other cells have an influence on C12, you could limit the execution of

Please Login or Register  to view this content.

to cases where it makes sense.

[Mike1001]

Maybe that's the "solves it all" version:

Please Login or Register  to view this content.

If any cells is changed from which M10 is an dependent, the message box will be shown when OVER or UNDER criteria are met.

[Mike1001]

Maybe that's the "solves it all" version:

Please Login or Register  to view this content.

If any cells is changed from which M10 is an dependent, the message box will be shown when OVER or UNDER criteria are met.