Control Format Properties

Name

Returns

Description

DropDownLines

Long

Set/Get how many lines are displayed in the drop-down part of a combo box. Valid only if the control is a combo box

Enabled

Boolean

Set/Get whether the control is enabled

LargeChange

Long

Set/Get the value that is added or subtracted every time the user clicks inside the scrollbar area for a scroll box. Valid only if the control is a scroll box

LinkedCell

String

Set/Get the range where the results of the control are placed

Name

Returns

Description

ListCount

Long

Read-only. Returns the number of items in the list box or combo box. Valid only for list box and combo box controls

ListFillRange

String

Set/Get the range that contains the items for a list box or combo box. Valid only for list box and combo box controls

ListIndex

Long

Set/Get the item that is currently selected in the list box or combo box. Valid only for list box and combo box controls

LockedText

Boolean

Set/Get whether the control text can be changed if the workbook is locked

Max

Long

Set/Get the maximum value allowed for a scrollbar or spinner. Valid only on a control that is a scrollbar or spinner

Min

Long

Set/Get the minimum value allowed for a scrollbar or spinner. Valid only on a control that is a scrollbar or spinner

MultiSelect

Long

Set/Get how a list box reacts to user selection. The property can be set to xlNone (only one item can be selected), xlSimple (each item the user clicks on is added to the selection), or xlExtended (the user has to hold down the Ctrl key to select multiple items). Valid only on list boxes

PrintObject

Boolean

Set/Get whether the control will be printed when the sheet is printed

SmallChange

Long

Set/Get the value that is added or subtracted every time the user clicks the arrow button associated with the scrollbar. Valid only if the control is a scroll box

Value

Long

Set/Get the value of the control

0 0

Post a comment