Application.CustomListCount Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns the number of defined custom lists (including built-in lists). Read-only Long.

expression .CustomListCount

expression A variable that represents an Application object.

This example displays the number of custom lists that are currently defined.

MsgBox "There are currently " & Application.CustomListCount & _ 
 " defined custom lists."