_Chart.ListBoxes(Object) Method

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Returns or sets the text entries in the specified list box or a combo box, as an array of strings, or returns or sets a single text entry. An error occurs if there are no entries in the list.

public object ListBoxes (object Index);

Public Function ListBoxes (Optional Index As Object) As Object

Parameters

Index

Object

The index number of a single text entry to be set or returned. If this argument is omitted, the entire list is returned or set as an array of strings.

Returns

Object

Variant

Examples

This example sets the entries in a list box on worksheet one. If Shapes(2) doesn’t represent a list box, this example fails.

<span class="label">Worksheets(1).Shapes(2).ControlFormat.</span>
<i>List</i>
<span class="label">= _     Array("cogs", "widgets", "sprockets", "gizmos")</span>

This example sets entry four in a list box on worksheet one. If Shapes(2) doesn’t represent a list box, this example fails.

<span class="label">Worksheets(1).Shapes(2).ControlFormat.</span>
<i>List</i>
<span class="label">(4) = "gadgets"</span>

This example sets the entries in a list box on worksheet one. If Shapes(2) doesn’t represent a list box, this example fails.

<span class="label">Worksheets(1).Shapes(2).ControlFormat.</span>
<i>List</i>
<span class="label">= _     Array("cogs", "widgets", "sprockets", "gizmos")</span>

This example sets entry four in a list box on worksheet one. If Shapes(2) doesn’t represent a list box, this example fails.

<span class="label">Worksheets(1).Shapes(2).ControlFormat.</span>
<i>List</i>
<span class="label">(4) = "gadgets"</span>

This example sets the entries in a list box on worksheet one. If Shapes(2) doesn’t represent a list box, this example fails.

<span class="label">Worksheets(1).Shapes(2).ControlFormat.</span>
<i>List</i>
<span class="label">= _     Array("cogs", "widgets", "sprockets", "gizmos")</span>

This example sets entry four in a list box on worksheet one. If Shapes(2) doesn’t represent a list box, this example fails.

<span class="label">Worksheets(1).Shapes(2).ControlFormat.</span>
<i>List</i>
<span class="label">(4) = "gadgets"</span>

Remarks

Setting this property clears any range specified by the ListFillRange property.