Forum home » Delegate support and help forum » Microsoft Project Training and help » Project deadline alert
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Project deadline alert
Resolved · High Priority · Version 2007
Reply Tue 4 Jan 2011, 11:57Delegate Dan said...
Dan has attended:
Project Intro Intermediate course
Project deadline alert
In my Project I have a final task entitled "Launch" which is my final milestone. Below this task I have another task titled "Deadline conveyed to Management".
Basically I told the Powers that be my baseline Launch date as a completion date and have managed to save myself some time so my current Launch date is actually earlier.
What I want to do is create a VBA msgbox alert so that if I start to slip I want it to warn me I've exceeded my deadline.
My VBA is pretty useless so I need the whole string of code. I want it to look at the "Launch" date and the "Deadline" date everytime I change something. If my Launch date exceeds my deadline date I want it to throw up a msgbox saying "Deadline exceeded!" or something.
Can this be done?
For upcoming training course dates see: Pricing & availability
RE: Project deadline alert
Hi Dan
Thank you for your question - VBA could probably do this for you - unfortunately though VBA is outside the scope of this forum.
An alternative would be to use the built in deadline feature in MS Project. It doesn't generate a pop up box but it will indicate if a task is running later than a date that is important to you.
To set this up in your project double click your final Launch task. On the advance tab set the deadline date to the "Deadline conveyed to management" date. An arrow shaped marker will appear in the schedule on the same line as the launch task. It points at the deadline date you set. Now if the launch task is delayed beyond the deadline date a red diamond shape indicator will appear beside the task's row to alert you.
I hope this helps - do let us know if you have any further questions.
Kind regards,
Andrew
Thu 13 Jan 2011: Automatically marked as resolved.
|