View Single Post
 
Old 10-22-2022, 06:47 AM
caspy caspy is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Oct 2022
Posts: 2
caspy is on a distinguished road
Lightbulb Counting the amount of comments 'done' and 'not done' with a macro

Long time listener, first time caller (poster).

Love some of these macros.

So the I noticed there is a comment.done property, but i haven't seen it used in a macro. My query is kinda simple, I know i can extract all comments into a table and stuff like that, but i simply want to count the amount of comments that are in a document on a given day, and also count the amount of comments marked as 'done'.

Is this possible to do with a macro? I imagine it'd only be a few lines but haven't dabbled in VBA for a very long time.

That's it really.

Thank you for your time!

background; instructional designer, implementing changes from SMEs.
Reply With Quote