Exporter (0) Imprimer
Développer tout
_Evaluate Method
_FindFile Method
_Run2 Method
_Wait Method
_WSFunction Method
ActivateMicrosoftApp Method
AddChartAutoFormat Method
AddCustomList Method
Calculate Method
CalculateFull Method
CalculateFullRebuild Method
CentimetersToPoints Method
CheckAbort Method
CheckSpelling Method
ConvertFormula Method
DDEExecute Method
DDEInitiate Method
DDEPoke Method
DDERequest Method
DDETerminate Method
DeleteChartAutoFormat Method
DeleteCustomList Method
DisplayXMLSourcePane Method
DoubleClick Method
Dummy1 Method
Dummy10 Method
Dummy11 Method
Dummy12 Method
Dummy13 Method
Dummy14 Method
Dummy2 Method
Dummy3 Method
Dummy4 Method
Dummy5 Method
Dummy6 Method
Dummy7 Method
Dummy8 Method
Dummy9 Method
Evaluate Method
ExecuteExcel4Macro Method
FindFile Method
GetCustomListContents Method
GetCustomListNum Method
GetOpenFilename Method
GetPhonetic Method
GetSaveAsFilename Method
Goto Method
Help Method
InchesToPoints Method
InputBox Method
Intersect Method
MacroOptions Method
MailLogoff Method
MailLogon Method
NextLetter Method
OnKey Method
OnRepeat Method
OnTime Method
OnUndo Method
Quit Method
RecordMacro Method
RegisterXLL Method
Repeat Method
ResetTipWizard Method
Run Method
Save Method
SaveWorkspace Method
SendKeys Method
SetDefaultChart Method
Support Method
Undo Method
Union Method
Volatile Method
Wait Method
Développer Réduire

_Application.AddCustomList Method

Adds a custom list for custom autofill and/or custom sort.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

'Utilisation
Dim ListArray As Object
Dim ByRow As Object
Dim _Application1 As _Application
_Application1.AddCustomList(ListArray, ByRow)

void AddCustomList(
	[In] object ListArray, 
	[In, Optional] object ByRow
);
public void AddCustomList(
	/*in*/System.Object ListArray, 
	/*in*/System.Object ByRow
);
function AddCustomList(
	 ListArray : Object, 
	 ByRow : Object
);

Parameters

ListArray

Required Object. Specifies the source data, as either an array of strings or a Range object.

ByRow

Optional Object. Only used if ListArray is a Range object. True to create a custom list from each row in the range. False to create a custom list from each column in the range. If this argument is omitted and there are more rows than columns (or an equal number of rows and columns) in the range, Microsoft Excel creates a custom list from each column in the range. If this argument is omitted and there are more columns than rows in the range, Microsoft Excel creates a custom list from each row in the range.

If the list you're trying to add already exists, this method does nothing.


Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Microsoft réalise une enquête en ligne pour recueillir votre opinion sur le site Web de MSDN. Si vous choisissez d’y participer, cette enquête en ligne vous sera présentée lorsque vous quitterez le site Web de MSDN.

Si vous souhaitez y participer,
Afficher:
© 2014 Microsoft