Excel Formula Question

[riptid3]

A1 has an EMBED Check Box. If checked (TRUE) then B1 shows the current date and time "NOW()" if unchecked (FALSE) B1 shows blank.

Whats the formula for A1 and B1?

I've got it working but my problem is I have, for example 15 rows. A1:A15 all have check boxes and B1:B15 have the time. But every time I uncheck a check box and recheck it, Excel puts the current date and time in B1:B15.

I don't want it to recalculate B1:B15 I just want it to calculate the next box in the row. A1 calcs time and date for B1. A2 calcs time for B2.... etc.

 

[riptid3]

There is an example here.

If you check 1 and leave it checked, wait a minute then check the other, the previous one will update it's date as well rather than keeping its original value.

http://www.lordsoftheunderdark.com/chadonly/Book1.zip