Application.LookUpTableAddEx method (Project)
Appends items to the lookup table of a custom outline code definition.
Syntax
expression. LookUpTableAddEx( _FieldID_, _Level_, _Code_, _Description_, _Phonetic_ )
expression A variable that represents an Application object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| FieldID | Required | Long | Specifies the custom outline code to edit. Can be one of the PjCustomField constants. |
| Level | Optional | Long | Specifies the level of the new code. The default value is the level of the last item in the lookup table. |
| Code | Optional | String | The code to be added to the lookup table. |
| Description | Optional | String | A description for the field specified in the Code argument. |
| Phonetic | Optional | String | The phonetic spelling of the Code argument, used for sorting order in Japanese. For languages other than Japanese, Phonetic is ignored. |
Return value
Boolean
Remarks
If only the FieldID argument is specified, the LookUpTableAddEx method displays the Lookup Table dialog box for the specified custom outline code.
Example
This example shows how it is possible to create an invalid entry in a lookup table. The first line correctly adds a new code to the second level of a two-level code mask. The second line, however, causes a problem in the lookup table because the appended code doesn't match the mask for the code; that is, it adds the new code at the third level of a two-level mask.
Sub LookupTableProblem()
Application.LookUpTableAddEx pjCustomTaskOutlineCode1, Level:=2, Code:="Q"
Application.LookUpTableAddEx pjCustomTaskOutlineCode1, Level:=3, Code:="Z"
End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.