ControlFormat Object Members

  • Article
Excel Developer Reference

Contains Microsoft Excel control properties.

Methods

  Name Description
Bb255950.methods(en-us,office.12).gif AddItem Adds an item to a list box or a combo box.
Bb255950.methods(en-us,office.12).gif List 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.
Bb255950.methods(en-us,office.12).gif RemoveAllItems Removes all entries from a Microsoft Excel list box or combo box.
Bb255950.methods(en-us,office.12).gif RemoveItem Removes one or more items from a list box or combo box.

Properties

  Name Description
Bb255950.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb255950.properties(en-us,office.12).gif DropDownLines Returns or sets the number of list lines displayed in the drop-down portion of a combo box. Read/write Long.
Bb255950.properties(en-us,office.12).gif Enabled True if the object is enabled. Read/write Boolean.
Bb255950.properties(en-us,office.12).gif 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). Read/write Long.
Bb255950.properties(en-us,office.12).gif LinkedCell Returns or sets the worksheet range linked to the control's value. If you place a value in the cell, the control takes this value. Likewise, if you change the value of the control, that value is also placed in the cell. Read/write String.
Bb255950.properties(en-us,office.12).gif ListCount Returns the number of entries in a list box or combo box. Returns 0 (zero) if there are no entries in the list. Read-only Long.
Bb255950.properties(en-us,office.12).gif ListFillRange Returns or sets the worksheet range used to fill the specified list box. Setting this property destroys any existing list in the list box. Read/write String.
Bb255950.properties(en-us,office.12).gif ListIndex Returns or sets the index number of the currently selected item in a list box or combo box. Read/write Long.
Bb255950.properties(en-us,office.12).gif LockedText True if the text in the specified object will be locked to prevent changes when the workbook is protected. Read/write Boolean.
Bb255950.properties(en-us,office.12).gif 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. Read/write Long.
Bb255950.properties(en-us,office.12).gif 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. Read/write Long.
Bb255950.properties(en-us,office.12).gif MultiSelect Returns or sets the selection mode of the specified list box. Can be one of the following constants: xlNone, xlSimple, or xlExtended. Read/write Long.
Bb255950.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb255950.properties(en-us,office.12).gif PrintObject True if the object will be printed when the document is printed. Read/write Boolean.
Bb255950.properties(en-us,office.12).gif 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). Read/write Long.
Bb255950.properties(en-us,office.12).gif Value Returns or sets a Long value that represents the name of specified control format.