warning box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I have a message come up when a cell breaks a record.
Example
if A4 is greater than 50 the say new record
 
How can I have a message come up when a cell breaks a record.
Example
if A4 is greater than 50 the say new record
Click to expand...

You mean an actual message box? If so, right click the sheet tab
where you want this to take place and select View Code. Then paste
something like this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A4").Text > 50 Then _
MsgBox "New Record!!!"
End Sub
 
JW, that worked perfectly. But how can I change the 50 to something else
without getting a compilr error?
Thanks
 
Back
Top