trigger msgbox when certain conditions are met

Joined
Nov 27, 2008
Messages
1
Reaction score
0
hello there
i've spent a long time looking for what i need on various forums. now it's time to post the specific question i'm trying to solve. i don't imagine that it will be too complicated for true experts (unlike me).

i want a message box to appear (with text that i shall write. something like "congratulations!") when 2 conditions are met.
these conditions are pretty simple.
one of them is if the sum of cells a1:a4 = 12 and the other is if the value in b1 = 1.
i guess these conditions need to trigger a macro which causes the message box to appear.
please help!
nik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top