Export (0) Print
Expand All

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



Community Additions

ADD
Show:
© 2014 Microsoft