Excel.Application.GetCustomListContents.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Application.GetCustomListContents method (Excel)	vbaxl10.chm133140	vbaxl10.chm133140	Excel.Application.GetCustomListContents	3adafb35-f7d0-0233-ff7c-c31d5e48f574	04/04/2019	medium

Application.GetCustomListContents method (Excel)

Returns a custom list (an array of strings).

Syntax

expression.GetCustomListContents (ListNum)

expression A variable that represents an Application object.

Parameters

Name	Required/Optional	Data type	Description
ListNum	Required	Long	The list number.

Return value

Variant

Example

This example writes the elements of the first custom list in column one on Sheet1.

listArray = Application.GetCustomListContents(1) 
For i = LBound(listArray, 1) To UBound(listArray, 1) 
 Worksheets("sheet1").Cells(i, 1).Value = listArray(i) 
Next i

[!includeSupport and feedback]