How to Get active task colum in project professional from VBA?

[Daniel Lee]

Hello:

I had to develop a vba module which could set come specific string to
active task column for example enterprisetext1 field in project professional.

My questiuon is as below:
1. If I click specific table row in project professional how could I get
the row related information in VBA?
2. How could I set specific string from VBA to sleected row specific column
in project professional?

Any comment will be very appreciated.

Regards.
Daniel Lee

 

[Jan De Messemaeker]

Hi,

1. Activeselection.fieldnamelist
2. For instance,
activeproject.tasks(i).text27=...
Do try to forget about row and columns, Project VBA is much richer in terms
of objects and properties.

HTH

 

[Daniel Lee]

Hello Jan:

Thanks for your assistance.
Now my problem is that how could I get the clicked task when user
clicked some specific task?

Best Regards,

Daniel Lee

 

[Jan De Messemaeker]

activeselection.tasks(1)

 

[Daniel Lee]

Thanks! I got it.

activeselection.tasks(1)

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620