customize fields

[Itzik]

How can I customize a task field with a formula using
resource field.
i.e. I am writing a formula for a task field and I want
to
use in that formula resource fields.
I don't mind using VBA.
Thanks

 

[Jan De Messemaeker]

Hi Itzik

In VBA that should look about like this

For each reso in thistask.resources
if reso.name= "....." then
thistask.text9=reso.text20
endif
next reso

Of course this has to be embedded in a procedure
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620

 

[Itzik]

I've added another cost rate in the resource sheet, and I
want to caculate the cost for this rate in the task usage
view (so, I'll have 2 cost columns in the task usage view:
one for the std. rate and the second for the cost rate
I've added).