ControlFormat.ListFillRange Property
Returns or sets the worksheet range used to fill the specified list box.
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 ControlFormat
Dim value As String
value = instance.ListFillRange
instance.ListFillRange = value
string ListFillRange { get; set; }
Property Value
Type: System.String
Remarks
Setting this property destroys any existing list in the list box.
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 ("").