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.
Bookmarks