Export (0) Print
Expand All

_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)

Dim _OLEObject1 As _OLEObject

Dim returnValue As String
returnValue = _OLEObject1.ListFillRange

Dim sampleValue As String
_OLEObject1.ListFillRange = sampleValue

string ListFillRange {get; set;}
public System.String get_ListFillRange();
public void set_ListFillRange(System.String);
function get ListFillRange() : String;
function set ListFillRange(String);

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 ("").

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

Community Additions

© 2014 Microsoft