Getting a MsgBox for non-Zero Balances

In theory the code should work. Reality says otherwise....Do you know what is wrong? Please check out the workbook.

Please Login or Register  to view this content.

Perhaps if you explain what Reality is?

The code seems to work. No message when the cell value <> 0, message when it is.

...Reality is I'm not the best at communicating online. I would like to get the code to work so a message box pops up if there is a non-zero number i.e. if 1 than msgbox, if 0 then no msgbox.

Thanks for your help.

Concentrate on this line...

Please Login or Register  to view this content.

VBA uses <> to indicate 'Not Equal To'...