How do i timestamp comment fields
 

i'm wondering i can i put in an instant timestamp when i add a comment to a
cell in microsoft excel.

i'd liek to also be able to edit the comment, and add a second timestamp two
line before the previous comment.

i'd think some programming would be invlolved. any ideas? good tutorials on
programming? what programming options do i have?

How do i timestamp comment fields
 

Ben,

I believe you need to create your own comment macro and use it instead. For
a start look he

http://www.contextures.com/xlcomments03.html#Plain

hth,

Doug

"BenMetz" wrote in message
...
i'm wondering i can i put in an instant timestamp when i add a comment to
a
cell in microsoft excel.

i'd liek to also be able to edit the comment, and add a second timestamp
two
line before the previous comment.

i'd think some programming would be invlolved. any ideas? good tutorials
on
programming? what programming options do i have?

How do i timestamp comment fields
 

thank you. i'll run through that and hopefully be able to do it. is it
possible to do this in VB/XML/microsoft script editor? i saw those functions
in excel but don't know how i'd utilize them.

"Doug Glancy" wrote:

Ben,

I believe you need to create your own comment macro and use it instead. For
a start look he

http://www.contextures.com/xlcomments03.html#Plain

hth,

Doug

"BenMetz" wrote in message
...
i'm wondering i can i put in an instant timestamp when i add a comment to
a
cell in microsoft excel.

i'd liek to also be able to edit the comment, and add a second timestamp
two
line before the previous comment.

i'd think some programming would be invlolved. any ideas? good tutorials
on
programming? what programming options do i have?

How do i timestamp comment fields
 

Ben,

You should write a VBA (Visual Basic for Applications) macro. VBA is a
version of VB that only runs inside Excel (or other programs). Open up the
Visual Basic Editor in Excel (Alt-F11) and write your code there. (You
could also do it in VB by automating Excel, but from your descritption I
don't think that's what you want.)

You should also look into the Macro Recorder in Excel. It generates VBA
code and is a great way to figure out how to code things.

There's lots of VBA resources on the net. Google and you'll find blogs,
pages, and archived newsgroups. www.j-walk.com and www.dicks-blog.com/ are
two good sites that will also point you many other resources.

Post back if that doesn't answer your question.

Doug

"BenMetz" wrote in message
...
thank you. i'll run through that and hopefully be able to do it. is it
possible to do this in VB/XML/microsoft script editor? i saw those
functions
in excel but don't know how i'd utilize them.

"Doug Glancy" wrote:

Ben,

I believe you need to create your own comment macro and use it instead.
For
a start look he

http://www.contextures.com/xlcomments03.html#Plain

hth,

Doug

"BenMetz" wrote in message
...
i'm wondering i can i put in an instant timestamp when i add a comment
to
a
cell in microsoft excel.

i'd liek to also be able to edit the comment, and add a second
timestamp
two
line before the previous comment.

i'd think some programming would be invlolved. any ideas? good
tutorials
on
programming? what programming options do i have?

How do i timestamp comment fields
 

Doug,
thanks for your assistance. helped for future references. but curious, is
it possible to do what i need to do by just selecting "Insert Comment" and
"Edit Comment" ? instead of running a macro everytime?

"Doug Glancy" wrote:

Ben,

You should write a VBA (Visual Basic for Applications) macro. VBA is a
version of VB that only runs inside Excel (or other programs). Open up the
Visual Basic Editor in Excel (Alt-F11) and write your code there. (You
could also do it in VB by automating Excel, but from your descritption I
don't think that's what you want.)

You should also look into the Macro Recorder in Excel. It generates VBA
code and is a great way to figure out how to code things.

There's lots of VBA resources on the net. Google and you'll find blogs,
pages, and archived newsgroups. www.j-walk.com and www.dicks-blog.com/ are
two good sites that will also point you many other resources.

Post back if that doesn't answer your question.

Doug

"BenMetz" wrote in message
...
thank you. i'll run through that and hopefully be able to do it. is it
possible to do this in VB/XML/microsoft script editor? i saw those
functions
in excel but don't know how i'd utilize them.

"Doug Glancy" wrote:

Ben,

I believe you need to create your own comment macro and use it instead.
For
a start look he

http://www.contextures.com/xlcomments03.html#Plain

hth,

Doug

"BenMetz" wrote in message
...
i'm wondering i can i put in an instant timestamp when i add a comment
to
a
cell in microsoft excel.

i'd liek to also be able to edit the comment, and add a second
timestamp
two
line before the previous comment.

i'd think some programming would be invlolved. any ideas? good
tutorials
on
programming? what programming options do i have?