Does anyone have a tip how to have entered a static date
and time stamp based upon a user entering anything in an
adjacent cell? I am looking to capture the time and date
of user data entries so I can track when those entries
are entered into different cells on a worksheet.

If I use the now() function to capture when an entry is
made, it doesn't get saved as a static entry, so the
value changes whenever the Enter key is hit. I have made
a macro that enters a date or time stamp into a cell, but
that means a user has to initiate the macro, which would
be an extra step and the user would likely forget to
invoke it. I wish to simplify it so the macro is envoked,
or a function is called whenever the spreadsheet is
updated (the Enter key is hit) but that the static time
and date don't get changed unless the cell with the data
entry is changed.

Thanks for any suggestions.

-George