Hi.

When a particular value is entered into one cell, I want to cause
another value to be set into a different cell. This different cell is
in the same row at an offset.

I wrote a little macro to cause an offset from the active cell to get
set, but I don't know how to cause this macro to run when the value is
changed in the "trigger" cell.

Specifically, I have a little "to-do" spreadsheet. One column
indicates completion status with a "Y" or "N". Another column
indicates completion date. So when the status changes to "Y", I want
that event to run the macro that will set the completion date to
Today().

Any help would be greatly appreciated!

Thanks,

Ken

P.S.: I am running Excel 97.