Automatic message when a condition is met.

[kangaris]

Hello,

I am trying to insert a macro that will pop up a message when a condition is met. I use the following code:

Sub Worksheet_Change(ByVal Target As Range)
    If Range("B4").Value < Range("C4").Value Then
        MsgBox ''Limit has been reached''
    End If
End Sub

However, it doesn't seem to work. It actually cannot be saved in my macros.

Can someone help?

Regards

Andreas

 

[Joe4]

Worksheet_Change event procedure code is only triggered to run when data on THAT sheet (the sheet the code is in) is updated manually.
Any changes that result from formulas or links would not trigger it to run. You would need to use a Worksheet_Calculate event procedure to capture that.

 

[kangaris]

Perfect!! This works now! Thanks everyone!

 

[Joe4]

You are welcome.
Glad we were able to help.