Application.CustomListCount Property (Excel)

Office 2013 and later
GitHub-Mark-64px

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."
Show: