Application.GetCustomListNum method (Excel)

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.


expression.GetCustomListNum (ListArray)

expression A variable that represents an Application object.


Name Required/Optional Data type Description
ListArray Required Variant An array of strings.

Return value



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


This example deletes a custom list.

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

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.