OLEObject.ListFillRange Property (2003 System)

Gets or sets a value that identifies the range used to fill the specified list box.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Public Property ListFillRange As String
'Usage
Dim instance As OLEObject
Dim value As String

value = instance.ListFillRange

instance.ListFillRange = value
public string ListFillRange { get; set; }

Property Value

Type: System.String
A value that identifies the range used to fill the specified list box.

Remarks

Microsoft Office Excel reads the contents of every cell in the range and inserts the cell values into the list box. The list tracks changes in the range’s cells.

Setting this property destroys any existing list in the list box.

If the list in the list box was created with the AddItem method, this property returns an empty string ("").

Permissions

See Also

Reference

OLEObject Class

OLEObject Members

Microsoft.Office.Tools.Excel Namespace