Dave O

You are an angel....thanks so much for your time but I think I have it
working using a circular reference....

I checked the iteration box under the tools/options/calculations menu and
set up this circular reference

=IF(B1="","",IF(A1="",NOW(),A1))

Now whenever I enter a comment in B, I get a static time/date stamp in A.
Haven't had any problems so far.

Thanks again
Cassandra

"Dave O" wrote:

No other ideas that are automated. To set it up with VBA you'd need to
determine the range of cells where comments are expected, and trigger
an event when one of those cells is changed. When that event triggers,
the code would insert the current date and time in the cell immediately
adjacent.

What is the tab name where the user is entering comments, and what is
the range of cells where this is likely to happen? It can be all of
column B, for instance, if that's the correct answer, just need to have
a range.

I have an answer for you, but it may take a while: I"m off to lunch and
then I have a series of meetings.