Calling VBA Function

[Guest]

Hi! I'm trying to 'ask' Excel to Beep evrytime a condition turns TRUE. For
example, every time cell A3 equals 10, beep. I did a Sub Noise () in VBA so I
could call that Sub in that If statement but how can I do it?

Thanks

 

[Guest]

Put the code below in the worksheet code module. Do this by right-clicking
on the sheet tab, and select view code. Then paste this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$3" And Target.Value = 10 Then Beep
End Sub