MS-Project VBA Question

Tutorials Win: Microsoft Windows Forum

Hi NG ,
I am new in the field of VBA and have a question / problem.
In one project file I defined a field ( customized field Number 13 )
and renamed it as "StatDur" and entered a formula there in.
With VBA I want to read out the contents of this field and display
it via MsgBox. Ihave entered following code

num = Application.CustomFieldValueListGetItem(pjCustomTaskNumber13,
pjValueListValue, 3)

Syntax is :
Ausdruck .CustomFieldValueListGetItem(FieldID, Item, Index)

Thats my code entered in VBA ( as above ):
num = Application.CustomFieldValueListGetItem(pjCustomTaskNumber13,
pjValueListValue, 3)

I want to store the contents of this field from row 3 in num and want to
display it via MsgBox.

It wont work since the VBA-Editor brings a failure where I am entering the
row number 3
as Index and I dont know why and how to solve this problem.
Can onyone give a helping hand.
Thanks in advance
Gruß

--
Cevikel
Tel. : 0911-433-6329
mailto:halidun.cevikel@siemens.com
Top

Re: MS-Project VBA Question by Doug

Doug
Mon Jan 16 06:33:55 CST 2006

Post to microsoft.public.project.vba

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Cevikel" <halidun.cevikel@siemens.com> wrote in message
news:dqfp5v$mdh$1@daniel-new.mch.sbs.de...
> Hi NG ,
> I am new in the field of VBA and have a question / problem.
> In one project file I defined a field ( customized field Number 13 )
> and renamed it as "StatDur" and entered a formula there in.
> With VBA I want to read out the contents of this field and display
> it via MsgBox. Ihave entered following code
>
> num = Application.CustomFieldValueListGetItem(pjCustomTaskNumber13,
> pjValueListValue, 3)
>
> Syntax is :
> Ausdruck .CustomFieldValueListGetItem(FieldID, Item, Index)
>
> Thats my code entered in VBA ( as above ):
> num = Application.CustomFieldValueListGetItem(pjCustomTaskNumber13,
> pjValueListValue, 3)
>
> I want to store the contents of this field from row 3 in num and want to
> display it via MsgBox.
>
> It wont work since the VBA-Editor brings a failure where I am entering the
> row number 3
> as Index and I dont know why and how to solve this problem.
> Can onyone give a helping hand.
> Thanks in advance
> Gruß
>
> --
> Cevikel
> Tel. : 0911-433-6329
> mailto:halidun.cevikel@siemens.com
>
>
>


Top