CODEWITHSUNDEEP
vbams-projectlookup-tables
Stephen Richards
Stephen Richards

Reputation: 23

Apart from adding entries via LookUpTableAddEx, , can VBA do more to the lookup table of a non-outline code custom field in MSProject?

For example, this works:

Application.LookUpTableAddEx FieldID:=pjCustomTaskNumber1, Level:=1, Code:="10", Description:="wow"

However, I am searching for a VBA way to edit the entries already in the lookuptable, or even a workaround to delete the lookuptable, then repopulate it with the updated entries. If not, I believe it is possible to edit the outline code lookup tables, but I'm specifically wanting to manipulate the non-outline code custom fields.

Below, the second line doesn't overwrite the first line, unfortunately for my purposes.

Application.LookUpTableAddEx FieldID:=pjCustomTaskNumber1, Level:=1, Code:="10", Description:="wow"

Application.LookUpTableAddEx FieldID:=pjCustomTaskNumber1, Level:=1, Code:="10", Description:="no wow"

Upvotes: 1

Views: 100

Answers (1)

Rachel Hettinger
Rachel Hettinger

Reputation: 8442

To manipulate the non-outline code custom fields such as Text1-30, Number1-30, use the methods such as:

Also, search SO for related posts.

Upvotes: 1

Related Questions