Add Method (DropDowns Collection)

Applies To

DropDowns Collection.

Description

Creates a new drop-down list box using rectangular coordinates specified in points (1/72 inch).

Syntax

object.Add(left, top, width, height, editable)

object

Required. The DropDowns object.

left, top, width, height

Required. Specifies the width, height, and initial coordinates of the upper left corner of the object, in points relative to the top left corner of cell A1 or the upper left corner of the chart.

editable

Optional. True if the drop-down list box can be edited. If this argument is False or omitted, the contents of the list-box editing region can be changed only by selecting from the list.

See Also

Add Method (Arcs and Lines), Add Method (Drawings Collection), Add Method (Graphic Objects and Controls), Duplicate Method.

Example

This example creates a drop-down list box on Sheet1.

With Worksheets("Sheet1").DropDowns.Add(10, 10, 120, 18)
    .DropDownLines = 10
End With