Use 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 ,
climax wrote:

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