Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Office and SharePoint development
Office client development
Office 2013
Excel 2013
Welcome to the Excel 2013 developer reference
Object model reference (Excel 2013 developer reference)
Application Object (Excel)
Application Methods (Excel)
Application.ActivateMicrosoftApp Method (Excel)
Application.AddCustomList Method (Excel)
Application.Calculate Method (Excel)
Application.CalculateFull Method (Excel)
Application.CalculateFullRebuild Method (Excel)
Application.CalculateUntilAsyncQueriesDone Method (Excel)
Application.CentimetersToPoints Method (Excel)
Application.CheckAbort Method (Excel)
Application.CheckSpelling Method (Excel)
Application.ConvertFormula Method (Excel)
Application.DDEExecute Method (Excel)
Application.DDEInitiate Method (Excel)
Application.DDEPoke Method (Excel)
Application.DDERequest Method (Excel)
Application.DDETerminate Method (Excel)
Application.DeleteCustomList Method (Excel)
Application.DisplayXMLSourcePane Method (Excel)
Application.DoubleClick Method (Excel)
Application.Evaluate Method (Excel)
Application.ExecuteExcel4Macro Method (Excel)
Application.FindFile Method (Excel)
Application.GetCustomListContents Method (Excel)
Application.GetCustomListNum Method (Excel)
Application.GetOpenFilename Method (Excel)
Application.GetPhonetic Method (Excel)
Application.GetSaveAsFilename Method (Excel)
Application.Goto Method (Excel)
Application.Help Method (Excel)
Application.InchesToPoints Method (Excel)
Application.InputBox Method (Excel)
Application.Intersect Method (Excel)
Application.MacroOptions Method (Excel)
Application.MailLogoff Method (Excel)
Application.MailLogon Method (Excel)
Application.NextLetter Method (Excel)
Application.OnKey Method (Excel)
Application.OnRepeat Method (Excel)
Application.OnTime Method (Excel)
Application.OnUndo Method (Excel)
Application.Quit Method (Excel)
Application.RecordMacro Method (Excel)
Application.RegisterXLL Method (Excel)
Application.Repeat Method (Excel)
Application.Run Method (Excel)
Application.SaveWorkspace Method (Excel)
Application.SendKeys Method (Excel)
Application.SharePointVersion Method (Excel)
Application.Undo Method (Excel)
Application.Union Method (Excel)
Application.Volatile Method (Excel)
Application.Wait Method (Excel)
Expand Minimize
This topic has not yet been rated - Rate this topic

Application.GetCustomListContents Method (Excel)

Office 2013

Published: July 16, 2012

Returns a custom list (an array of strings).

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

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

VBA
Copy 
listArray = Application.GetCustomListContents(1) 
For i = LBound(listArray, 1) To UBound(listArray, 1) 
 Worksheets("sheet1").Cells(i, 1).Value = listArray(i) 
Next i
Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.