Programmatically set drop down choice

[Glen]

How can a custom field with a value list be set to a
particular value programatically? For instance if a
Enterprise Project text field has 10 values, how can VBA
be used to set the 3rd value?

 

[Rod Gill]

Hi,

Try recording a macro to do that manually. The recorded code will give you
most of your answer. If nothing gets recorded, it typically means there
isn't a VBA method for it.

 

[Glen]

Thanks
I was too tired to think of that. It is not the whole
answer. You can set it to a particular vlaue in the
value list, however you have to know what the values are.

 

[Jan De Messemaeker]

Hi Glen,

Here's an example. If bnecessary you can look up the help for the method.

activeproject.Tasks(3).Text1=customfieldvaluelistgetitem(pjCustomTaskText1,p
jValueListValue,5)
HTH