Hi Ben

Only possible with code as far as I know

See this page
http://www.contextures.com/xlcomments01.html



--
Regards Ron de Bruin
http://www.rondebruin.nl


"BenMetz" wrote in message ...
I am looking for a small piece of code that will format a comment feild in
microsoft excel to start with the current date and time.

this is details of what exactly the code needs to do:

1.Insert Comment
2.Code inserts date and timestamp into the newly opened comment field.
3.If you select "Edit Comment", it will create a two 's after the last typed
word (paragraph). And then timestamp there.

could anyone lend a hand? (well, alittle more than a hand)