How to detect PayRate change?

[Jonathan Fong]

Does anyone know how can I detect the PayRate change from VBA when I change
the pay rate in a resource.

Regards,
Jonathan

 

[John]

Jonathan,
I'm a little confused. If you know you changed the pay rate in a
resource, what exactly are you trying to detect? There must be more to
it.

John

 

[Jonathan Fong]

John

I am trying to catch the pay rate change and do some recalculation in
another application. For example, we can increase and decrease the pay rate
in the consecutive years by percentage, let say 10 years but when I go back
and change the value in the first year, it doesn't automatically reflect in
the rest of the years. Does it have anyway to improve this process?

Jonathan

 

[John]

Jonathan,
If I understand you correctly, you have a plan with a payrate structure
that is currently set for a particular value for each resource in year
1. Each successive year the payrate increases by a certain percentage.
You would like to be able to go in to any given year for any resource
and change the payrate and then be able to see the reflected change in
all other years - correct?

My first though was to apply a formula to the payrate fields but I don't
think that is possible with current versions of Project (if I'm wrong,
maybe someone can enlighten us both). My second thought is to capture
the year one payrate for each resource in a spare resource field (e.g.
Number or Text) for reference. Then write a macro that queries the
current payrate with the reference and if a change is detected,
re-adjust the payrate of all other years to reflect the change. This may
seem a little complex but the macro should really be quite simple and
straightforward.

John

 

[Jonathan Fong]

Thanks John! I know what to do now.

Jonathan