Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export comment fields | Excel Discussion (Misc queries) | |||
How can I change the default settings for Comment fields in Excel. | Excel Discussion (Misc queries) | |||
How can I edit a comment w/o first having to select Show Comment | Excel Discussion (Misc queries) | |||
a comment plugin & copy paste directly from excel to comment ? fr. | Excel Worksheet Functions | |||
timestamp on each row... | Excel Programming |