This documentation is archived and is not being maintained.

Application.GetCustomListNum Method

Office 2007
Returns the custom list number for an array of strings. You can use this method to match both built-in lists and custom-defined lists.

Syntax

expression.GetCustomListNum(ListArray)

expression   A variable that represents an Application object.

Parameters

NameRequired/OptionalData TypeDescription
ListArrayRequiredVariantAn array of strings.

Return Value
Long

Remarks

This method generates an error if there's no corresponding list.

Example

This example deletes a custom list.

Visual Basic for Applications
n = Application.GetCustomListNum(Array("cogs", "sprockets", _
    "widgets", "gizmos"))
Application.DeleteCustomList n



Show: