warning box

[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

 

[JW]

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

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

 

[Debra Dalgleish]

You can use data validation to display a message. There are instructions
in Excel's Help, and here:

http://www.contextures.com/xlDataVal01.html

 

[Guest]

JW, that worked perfectly. But how can I change the 50 to something else
without getting a compilr error?
Thanks