Running a macro when a cell value changes

[Emea training]

How can I run a macro called "sounds", when a value within a spreadshee
ie: cell A1 goes over a pre-defined value, located in another cell (sa
a2)?

I have tried but am failing

 

[Don Guillett]

Norm,
:You may want to check your system clock unless xmas is already passed for
you.

--
Don Guillett
SalesAid Software
(e-mail address removed)

Hi Emea,

If the Sounds macro is in a standard module in the workbook,

Right-click the worksheet tab, select View Code and paste the following:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Range("A1"), Target) Is Nothing Then
If Range("A1").Value > Range("A2").Value Then
Sounds
End If
End If
End Sub

 

[Norman Jones]

Hi Don,

:You may want to check your system clock unless xmas is already passed for
you.

Thank you .

A couple of weeks back my clock was off for a couple of hours - the result
of some injudicious system experimentation.

As for Xmas, I find that it has (almost) always passed for me!

 

[Norman Jones]

Hi Emea,

If the Sounds macro is in a standard module in the workbook,

Right-click the worksheet tab, select View Code and paste the following:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Range("A1"), Target) Is Nothing Then
If Range("A1").Value > Range("A2").Value Then
Sounds
End If
End If
End Sub