Applies To
DrawingObjects Collection, DropDown Object, DropDowns Collection, ListBox Object, ListBoxes Collection.
Description
Returns or sets the worksheet range used to fill the list box, as a string. Setting this property destroys any existing list in the list box. Read-write.
Remarks
Microsoft Excel reads the contents of every cell in the range and puts it into the list box. The list will track changes in the range cells.
If the list in the list box was created with the AddItem method, this property returns an empty string ("").
See Also
AddItem Method, List Property, RemoveItem Method.
Example
This example fills list box one with the range A1:A10 on Sheet1.
DialogSheets("Dialog1").Listboxes(1).ListFillRange = _
"Sheet1!A1:A10"