Pop-up message if condition not met

[MimikeB]

I need help, please.
I would like to assign "weights" to certain conditions in a column. The total should add to 100. I would like to trigger a message box, warning that the condition is not met, and the difference between the sum of the amounts entered and 100.
Thanks!

[FDibbins]

Dont really need a message box for this (which would require VBA), you could just put something in a cell that says something like...
=if(sum(your-range)<>100,"TARGET Not Reached Yet","")

[MimikeB]

I am OK using VBA, but I don’t know how to trigger the appearance of a message when a cell becomes active.

[FDibbins]

Did you consider using something like the formula I suggested?

[Logit]

.
Paste in the sheet level module :

Please Login or Register  to view this content.

[MimikeB]

Yes, thank you, It’s a possibility.

[MimikeB]

I will try it, thank you,