How can I trigger a Macro when the value in a cell is changed?
Or can I have my macro triggd if any cell on my workshhet is changed?

Hi Sören,

Yes, with an event macro stored inthe module of the respectiv
worksheet:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$10" Then '<<<< change cell to suit you
needs
yourcode
End Sub

HTH
Cheers
Cari

--
Cari
-----------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...fo&userid=3325
View this thread: http://www.excelforum.com/showthread.php?threadid=53179

Hi Carim,

Thanks for the help.
It works very good.

I have also tested to skip the If-statment to get it to trigg on all type of
changes in the worksheet. But it does not work so good.
It hangs Excel at 100% CPU-load. So I skip that.

BR,
/Sören


"Carim" wrote:


Hi Sören,

Yes, with an event macro stored inthe module of the respective
worksheet:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$10" Then '<<<< change cell to suit your
needs
yourcode
End Sub

HTH
Cheers
Carim


--
Carim
------------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=531794