Shapes.AddFormControl method (Excel)

Creates a Microsoft Excel control. Returns a Shape object that represents the new control.

Syntax

expression.AddFormControl (Type, Left, Top, Width, Height)

expression A variable that represents a Shapes object.

Parameters

Name	Required/Optional	Data type	Description
Type	Required	XlFormControl	The Microsoft Excel control type. You cannot create an edit box on a worksheet.
Left	Required	Long	The initial coordinates of the new object (in points) relative to the upper-left corner of cell A1 on a worksheet or to the upper-left corner of a chart.
Top	Required	Long	The initial coordinates of the new object (in points) relative to the top of row 1 on a worksheet, or to the top of the chart area on a chart.
Width	Required	Long	The initial size of the new object, in points.
Height	Required	Long	The initial size of the new object, in points.

Return value

Shape

Remarks

Use the AddOLEObject method or the Add method of the OLEObjects collection to create an ActiveX control.

Example

This example adds a list box to worksheet one and sets the fill range for the list box.

With Worksheets(1) 
 Set lb = .Shapes.AddFormControl(xlListBox, 100, 10, 100, 100) 
 lb.ControlFormat.ListFillRange = "A1:A10" 
End With

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.