Forum Discussion
Capture Actual Date Task Was Checked Off
Is there any way to capture when a task was actually checked off using either a custom formula or maybe some fields I am not aware of? Or what about Finish Variance? Is there a way to use that field ...
Thanks, do you have any insight on how I might go about creating the macro?
Jamie Salbeck,
Sure, here is an article on how to set up the project change event. You need to be careful when using the change event so it is isolated to fire only when a specific change occurs, like when percent complete equals 100%.
https://learn.microsoft.com/en-us/office/vba/api/project.project.change
Sure, here is an article on how to set up the project change event. You need to be careful when using the change event so it is isolated to fire only when a specific change occurs, like when percent complete equals 100%.
https://learn.microsoft.com/en-us/office/vba/api/project.project.change
- Thank you so much for your help, I will take a look!
- Jamie Salbeck,
You're welcome and thanks for the feedback.
John- John,
Have you ever created something like this? Just looking it seems to be beyond my level of experience. I'm wondering if I can use the example they provide as a starting point and tweak it to my needs.