MsgBox dependant on sum and IF functionality

Hi everyone,

I've googled to my hearts content and can't find anything that could help me. It's been a very long time since I used VBA and so I can't remember much!

What I require is a message box to pop up stating "Warning!" based on the sum of certain cells and if they are greater than the sum of other cells.

E.G.

If sum of A1+B1 is greater than sum of C1*D4, then Message box pops up.

I know that the answer will be relatively simple but no matter how many hours I spend trying, I just can't seem to work it out!

Thank you in advance,

Kate

Hi Steve,

Thank you for your reply

However I am unable to get it to work. I don't quite understand how it works?

Kate

Hi Steve,

Thank you for your reply .

The above kind of does the job, but there is an odd delay, sometimes it takes a few clicks on different cells before the message box appears.

Is there any way to make it instantaneous as soon as you hit enter on the value?

Thanks again,

Kate

Thanks Steve for your reply

Here try this. It will replace the code you have already placed in the worksheet code page.

It will only trigger the message box if the values in cells A1,B2,C1 or D4 change and the sum of a1 and b1 is greater than c1 * d4.

Please Login or Register  to view this content.