Back to Devexpress

FormControlCollection.AddListBox(Single, Single, Single, Single) Method

officefileapi-devexpress-dot-spreadsheet-dot-formcontrolcollection-dot-addlistbox-x28-system-dot-single-system-dot-single-system-dot-single-system-dot-single-x29.md

latest3.1 KB
Original Source

FormControlCollection.AddListBox(Single, Single, Single, Single) Method

Creates a list box form control in the specified worksheet area.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
ListBoxFormControl AddListBox(
    float x,
    float y,
    float width,
    float height
)
vb
Function AddListBox(
    x As Single,
    y As Single,
    width As Single,
    height As Single
) As ListBoxFormControl

Parameters

NameTypeDescription
xSingle

The distance from the left of the worksheet. The ISpreadsheetComponent.Unit property specifies the unit of measurement.

| | y | Single |

The distance from the top of the worksheet. The ISpreadsheetComponent.Unit property specifies the unit of measurement.

| | width | Single |

The form control width.

| | height | Single |

The form control height.

|

Returns

TypeDescription
ListBoxFormControl

The list box form control.

|

Remarks

Example

The code sample below creates a list box control:

csharp
using DevExpress.Spreadsheet;

Workbook workbook = new Workbook();
workbook.LoadDocument("Document.xlsx");

var listBoxControl = formControls.AddListBox(20, 20, 300, 100);

listBoxControl.SourceRange = workbook.Worksheets[0].Range["E2:E6"];
listBoxControl.SelectedIndex = 1;
vb
Imports DevExpress.Spreadsheet

Dim workbook As New Workbook()
workbook.LoadDocument("Document.xlsx")

Dim listBoxControl = formControls.AddListBox(20, 20, 300, 100)

listBoxControl.SourceRange = workbook.Worksheets(0).Range("E2:E6")
listBoxControl.SelectedIndex = 1

Note

The FormControlCollection.AddListBox method call adds a new item to both FormControlCollection and ShapeCollection.

See Also

FormControlCollection Interface

FormControlCollection Members

DevExpress.Spreadsheet Namespace