software

Hi,

I want to trigger a script whenever the data changes in a cell.
For testing purposes I used this little script:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range(quot;c1quot;)) Is Nothing Then
Range(quot;a1quot;) = 1
End If
End Sub

The problem:
If I type something in c1 everything goes ok
But when I put this in c1= e1 and change the data in e1, c1 changes but
nothing happens to a1

How can I trigger the script thru a link that changes?

Thanks--
climax
------------------------------------------------------------------------
climax's Profile: www.excelforum.com/member.php...oamp;userid=30816
View this thread: www.excelforum.com/showthread...hreadid=507589Use the Worksheet_Calculate method instead.

Or, run the _Change method off of the input to your cell (e.g., E1 in
your example)
In article gt;,
climax gt; wrote:

gt; How can I trigger the script thru a link that changes?