After Update VBA

[NevilleT]

I have used VBA a lot in Access but not much in Project. I am using MSP2000
and want to update a task field (%complete), when a calculated custom field
changes(Number 1). Is there a command such as afterUpdate I can use in
Project?

 

[Earl Lewis]

Neville,

Try the project_change event. An excerpt from the project vba help follows.
++++++++++++++++++++++++
Change Event
See AlsoApplies ToExampleSpecificsOccurs when a change is made to data in the project. An action affecting several items at once is considered to be one change.

Syntax
Private Sub Project_Change(ByVal pj As MSProject.Project)

pj The project that changed.

Remarks
The Change event does not occur for actions such as switching views, applying filters, changing formatting, and so on.

Project events do not occur when the project is embedded in another document or application.

++++++++++++++++++++++++++++++++++++++++++++
End help excerpt

Earl
I have used VBA a lot in Access but not much in Project. I am using MSP2000
and want to update a task field (%complete), when a calculated custom field
changes(Number 1). Is there a command such as afterUpdate I can use in
Project?

 

[Brian K - Project MVP]

I have used VBA a lot in Access but not much in Project. I am using
MSP2000 and want to update a task field (%complete), when a
calculated custom field changes(Number 1). Is there a command such
as afterUpdate I can use in Project?

I wrote this for techrepublic years ago but it covers the exact event
you are talking about.

http://techrepublic.com.com/5100-6313_11-5032122.html?tag=search

 

[NevilleT]

I wrote this for techrepublic years ago but it covers the exact event
you are talking about.

http://techrepublic.com.com/5100-6313_11-5032122.html?tag=search

 

[Brian K - Project MVP]

Thanks Brian. That is exactly what I was looking for.

Great! Glad to help.