ControlFormat ControlFormat ControlFormat Interface

Definition

Contains Microsoft Excel control properties.

public interface class ControlFormat
[System.Runtime.InteropServices.Guid("00024440-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface ControlFormat
Public Interface ControlFormat
Attributes

Remarks

Use the ControlFormat property to return a ControlFormat object.

If the shape isn’t a control, the ControlFormat property fails, and if the control isn’t a list box, the ListFillRange property fails.

Properties

_Default _Default _Default

Reserved for internal use.

Application Application Application

Returns an Application object that represents the Microsoft Excel application.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created.

DropDownLines DropDownLines DropDownLines

Returns or sets the number of list lines displayed in the drop-down portion of a combo box.

Enabled Enabled Enabled

True if the object is enabled.

LargeChange LargeChange LargeChange

Returns or sets the amount that the scroll box increments or decrements for a page scroll (when the user clicks in the scroll bar body region).

LinkedCell LinkedCell LinkedCell

Returns or sets the worksheet range linked to the control's value.

List[Object] List[Object] List[Object]

Returns or sets the text entries in the specified list box or a combo box, as an array of strings, or returns or sets a single text entry. An error occurs if there are no entries in the list.

ListCount ListCount ListCount

Returns the number of entries in a list box or combo box. Returns 0 (zero) if there are no entries in the list.

ListFillRange ListFillRange ListFillRange

Returns or sets the worksheet range used to fill the specified list box.

ListIndex ListIndex ListIndex

Returns or sets the index number of the currently selected item in a list box or combo box.

LockedText LockedText LockedText

True if the text in the specified object will be locked to prevent changes when the workbook is protected.

Max Max Max

Returns or sets the maximum value of a scroll bar or spinner range. The scroll bar or spinner won’t take on values greater than this maximum value.

Min Min Min

Returns or sets the minimum value of a scroll bar or spinner range. The scroll bar or spinner won’t take on values less than this minimum value.

MultiSelect MultiSelect MultiSelect

Returns or sets the selection mode of the specified list box. Can be one of the following constants: xlNone, xlSimple, or xlExtended.

Parent Parent Parent

Returns the parent object for the specified object.

PrintObject PrintObject PrintObject

True if the object will be printed when the document is printed.

SmallChange SmallChange SmallChange

Returns or sets the amount that the scroll bar or spinner is incremented or decremented for a line scroll (when the user clicks an arrow).

Value Value Value

The name of specified control format.

Methods

AddItem(String, Object) AddItem(String, Object) AddItem(String, Object)

Adds an item to a list box or a combo box.

RemoveAllItems() RemoveAllItems() RemoveAllItems()

Removes all entries from a Microsoft Excel list box or combo box.

RemoveItem(Int32, Object) RemoveItem(Int32, Object) RemoveItem(Int32, Object)

Removes one or more items from a list box or combo box.

Applies to