Hi,
I would like to write a vba code to highlight tasks that has been
overdued for 1 week.
any help here?
thanks in advance
Hi Lynn,
maybe you can do it with a custom filter?
Cheers Michael
More easily done with a filter or formula I think.
It depends on what you mean by "over due" ... Let assume you mean the
baseline start date and the current forecasted start date are greater than a
week apart...
For a forumula, calculate the difference between [Baseline Start] and
[Start]. filter on that for >7 days. The date difference function will help
you. To create a formula, insert a column for a spare field (say Number1)
and then right click on the column header, select "Customize Fields..."
Select formula. Remember to apply the formula to the summary tasks as well.
If you mean "over due" becuase the forecast start date is in the past and
there is no %Complete or Actual Start date, then you have a bigger problem.
You would want to create a filter Project/Filter/More Filters/New...
Your conditions would be:
[Start]=NA
AND [Start]<=[Status Date]
Actually, you may not be able to access 'Status Date' so you could either
key a date, or enter a phrase "Enter Date" and then Project will ask you for
a date each time you run the filter.
Remember the four golden rules:
1. There are no tasks to the left of the status date that have not started.
2. There are no tasks with a finish to th eleft of the status date that have
not finished.
3. No task with a [start] to the right of the status date has an [Actual
Start] ... you did not start it tomorrow... the latest you could have started
was the status date unless you have some type of "in" with Einstein or Newton.
4. No task with a [Finish] to the right of the status date has an [Actual
Finish]... you did not finish tomorrow, you finished at the latest of the
status date.
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:http://www.msprojectblog.com
how to do that?- Hide quoted text -
- Show quoted text -
More easily done with a filter or formula I think.
It depends on what you mean by "over due" ... Let assume you mean the
baseline start date and the current forecasted start date are greater than
a
week apart...
For a forumula, calculate the difference between [Baseline Start] and
[Start]. filter on that for >7 days. The date difference function will
help
you. To create a formula, insert a column for a spare field (say Number1)
and then right click on the column header, select "Customize Fields..."
Select formula. Remember to apply the formula to the summary tasks as
well.
If you mean "over due" becuase the forecast start date is in the past and
there is no %Complete or Actual Start date, then you have a bigger
problem.
You would want to create a filter Project/Filter/More Filters/New...
Your conditions would be:
[Start]=NA
AND [Start]<=[Status Date]
Actually, you may not be able to access 'Status Date' so you could either
key a date, or enter a phrase "Enter Date" and then Project will ask you
for
a date each time you run the filter.
Remember the four golden rules:
1. There are no tasks to the left of the status date that have not
started.
2. There are no tasks with a finish to th eleft of the status date that
have
not finished.
3. No task with a [start] to the right of the status date has an [Actual
Start] ... you did not start it tomorrow... the latest you could have
started
was the status date unless you have some type of "in" with Einstein or
Newton.
4. No task with a [Finish] to the right of the status date has an [Actual
Finish]... you did not finish tomorrow, you finished at the latest of the
status date.
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:http://www.msprojectblog.com
how to do that?- Hide quoted text -
- Show quoted text -
Lynn said:Hi,
I do not want to insert formula into my file because this will be sent
out to others.
Therefore macro is the only way. And I have 2 other criterias to
highlight other than this mentioned
More easily done with a filter or formula I think.
It depends on what you mean by "over due" ... Let assume you mean the
baseline start date and the current forecasted start date are greater than a
week apart...
For a forumula, calculate the difference between [Baseline Start] and
[Start]. filter on that for >7 days. The date difference function will help
you. To create a formula, insert a column for a spare field (say Number1)
and then right click on the column header, select "Customize Fields..."
Select formula. Remember to apply the formula to the summary tasks as well.
If you mean "over due" becuase the forecast start date is in the past and
there is no %Complete or Actual Start date, then you have a bigger problem.
You would want to create a filter Project/Filter/More Filters/New...
Your conditions would be:
[Start]=NA
AND [Start]<=[Status Date]
Actually, you may not be able to access 'Status Date' so you could either
key a date, or enter a phrase "Enter Date" and then Project will ask you for
a date each time you run the filter.
Remember the four golden rules:
1. There are no tasks to the left of the status date that have not started.
2. There are no tasks with a finish to th eleft of the status date that have
not finished.
3. No task with a [start] to the right of the status date has an [Actual
Start] ... you did not start it tomorrow... the latest you could have started
was the status date unless you have some type of "in" with Einstein or Newton.
4. No task with a [Finish] to the right of the status date has an [Actual
Finish]... you did not finish tomorrow, you finished at the latest of the
status date.
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:http://www.msprojectblog.com
Lynn said:I would like to write a vba code to highlight tasks that has been
overdued for 1 week.any help here?thanks in advanceHi Lynn,
maybe you can do it with a custom filter?
Cheers Michaelhow to do that?- Hide quoted text -
- Show quoted text -
I already have these types of macros written/tested. However, this is not
freeware.
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:http://www.msprojectblog.com
Lynn said:I do not want to insert formula into my file because this will be sent
out to others.Therefore macro is the only way. And I have 2 other criterias to
highlight other than this mentionedMore easily done with a filter or formula I think.
It depends on what you mean by "over due" ... Let assume you mean the
baseline start date and the current forecasted start date are greaterthan a
week apart...
For a forumula, calculate the difference between [Baseline Start] and
[Start]. filter on that for >7 days. The date difference function will help
you. To create a formula, insert a column for a spare field (say Number1)
and then right click on the column header, select "Customize Fields...."
Select formula. Remember to apply the formula to the summary tasksas well.
If you mean "over due" becuase the forecast start date is in the pastand
there is no %Complete or Actual Start date, then you have a bigger problem.
You would want to create a filter Project/Filter/More Filters/New...
Your conditions would be:
[Start]=NA
AND [Start]<=[Status Date]
Actually, you may not be able to access 'Status Date' so you could either
key a date, or enter a phrase "Enter Date" and then Project will ask you for
a date each time you run the filter.
Remember the four golden rules:
1. There are no tasks to the left of the status date that have not started.
2. There are no tasks with a finish to th eleft of the status date that have
not finished.
3. No task with a [start] to the right of the status date has an [Actual
Start] ... you did not start it tomorrow... the latest you could havestarted
was the status date unless you have some type of "in" with Einstein or Newton.
4. No task with a [Finish] to the right of the status date has an [Actual
Finish]... you did not finish tomorrow, you finished at the latest ofthe
status date.
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:http://www.msprojectblog.com
:
Hi,
I would like to write a vba code to highlight tasks that has been
overdued for 1 week.
any help here?
thanks in advance
Hi Lynn,
maybe you can do it with a custom filter?
Cheers Michael
how to do that?- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.