Share via


_OLEObject.ListFillRange Property

Returns or sets the worksheet range used to fill the specified list box. Setting this property destroys any existing list in the list box. Read/write String.

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

Syntax

'Declaration
Property ListFillRange As String
    Get
    Set
'Usage
Dim instance As _OLEObject
Dim value As String

value = instance.ListFillRange

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

Property Value

Type: System.String

Remarks

Microsoft 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.

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

See Also

Reference

_OLEObject Interface

_OLEObject Members

Microsoft.Office.Interop.Excel Namespace