ControlFormat.ListFillRange Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Returns or sets the worksheet range used to fill the specified list box.

public:
 property System::String ^ ListFillRange { System::String ^ get(); void set(System::String ^ value); };

public string ListFillRange { get; set; }

Public Property ListFillRange As String

Property Value

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(String, Object) method, this property returns an empty string ("").

Applies to