Cell change to trigger Macro

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 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

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
>
>