| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
OLEObject.ListFillRange property (Excel) |
vbaxl10.chm417082 |
|
|
d8a44f9f-49bb-237b-66c8-9f6c06fe82ac |
05/02/2019 |
medium |
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.
expression.ListFillRange
expression A variable that represents an OLEObject object.
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 of the ControlFormat object, this property returns an empty string ("").
[!includeSupport and feedback]