View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SG
 
Posts: n/a
Default Message box if cell is greater than less than 0 [Zero]

Can someone help me with a code that can display a message box if a cell is
greater than less than 0 [Zero]

I have a column with each cell containing the following...

=SUM(C2:W2)
=SUM(C3:W3)
=SUM(C4:W4)
=SUM(C5:W5)
and so on

At the end of the day I have to scroll over and look down the column to see
if anything other than zero is there. If it is I have to go back and correct
my typo mistakes.

I need VB code when I enter data into cells that will alert me right then so
I can make the change I need.

All the best,

SG