Excel Macro for Cell LastModified

[mytamagotchi]

Hey all
I have a cell which needs to put a time stamp to keep track of the last modified.
Any ideas??

Thanks a lot

[spyder]

Try this:

Dim myString
Set myString = Date$
ActiveCell.insert myString

Your Macro Should Set the active Cell that you want the Date to be on