DropDowns Method

Applies To

Chart Object, DialogSheet Object, Worksheet Object.

Description

Accessor. Returns an object that represents a single drop-down list box control (a DropDown object, Syntax 1) or a collection of drop-down list box controls (a DropDowns object, Syntax 2) on the sheet.

Syntax 1

object.DropDowns(index)

Syntax 2

object.DropDowns

object

Required. The Chart, DialogSheet, or Worksheet object.

index

Required for Syntax 1. Specifies the name or number of the drop-down list box control (can be an array to specify more than one).

Example

This example sets the number of list lines in drop-down list box one on Dialog1.

DialogSheets("Dialog1").DropDowns(1).DropDownLines = 10