If there is already a macro behind the checkbox then try adding:

Selection.Value = Now()

to it. This will stick the value of now() in the range rather than the
formula itself.
--
Gary's Student


"Maliniemi" wrote:

Trying to add checkbox to form that enters date in associated cell to note
the date that the box was checked. NOW and TODAY functions recalculate all
dates on spreadsheet everytime it is opened to current date time. Please
help. Thanx.