Methods

getBackOleColor()

Gets and sets the ole color of the background.

getBorderOleColor()

Gets and sets the ole color of the background.

getBorderStyle()

Gets and set the type of border used by the control. The value of the property is ControlBorderType integer constant.

getBoundColumn()

Represents how the Value property is determined for a ComboBox or ListBox when the MultiSelect properties value (fmMultiSelectSingle).

getColumnCount()

Represents the number of columns to display in a ComboBox or ListBox.

getColumnWidths()

Gets and sets the width of the column.

getData()

Gets and sets the binary data of the control.

getDropButtonStyle()

Specifies the symbol displayed on the drop button The value of the property is DropButtonStyle integer constant.

getEnterFieldBehavior()

Specifies selection behavior when entering the control. True specifies that the selection remains unchanged from last time the control was active. False specifies that all the text in the control will be selected when entering the control.

getFont()

Represents the font of the control.

getForeOleColor()

Gets and sets the ole color of the foreground. Not applies to Image control.

getHeight()

Gets and sets the height of the control in unit of points.

getHideSelection()

Indicates whether selected text in the control appears highlighted when the control does not have focus.

getIMEMode()

Gets and sets the default run-time mode of the Input Method Editor for the control as it receives focus. The value of the property is InputMethodEditorMode integer constant.

getLinkedCell()

Gets and sets the linked cell.

getListFillRange()

Gets and sets the list fill range.

getListRows()

Represents the maximum number of rows to display in the list.

getListStyle()

Gets and sets the visual appearance. The value of the property is ControlListStyle integer constant.

getListWidth()

Gets and set the width in unit of points.

getMatchEntry()

Indicates how a ListBox or ComboBox searches its list as the user types. The value of the property is ControlMatchEntryType integer constant.

getMaxLength()

Gets and sets the maximum number of characters

getMouseIcon()

Gets and sets a custom icon to display as the mouse pointer for the control.

getMousePointer()

Gets and sets the type of icon displayed as the mouse pointer for the control. The value of the property is ControlMousePointerType integer constant.

getSelectionMargin()

Indicates whether the user can select a line of text by clicking in the region to the left of the text.

getShadow()

Indicates whether to show a shadow.

getShowColumnHeads()

Indicates whether column headings are displayed.

getShowDropButtonTypeWhen()

Specifies the symbol displayed on the drop button The value of the property is ShowDropButtonType integer constant.

getSpecialEffect()

Gets and sets the special effect of the control. The value of the property is ControlSpecialEffectType integer constant.

getTextAlign()

Represents how to align the text used by the control. The value of the property is TextAlignmentType integer constant.

getTextColumn()

Represents the column in a ComboBox or ListBox to display to the user.

getType()

Gets the type of the ActiveX control. The value of the property is ControlType integer constant.

getValue()

Gets and sets the value of the control.

getWidth()

Gets and sets the width of the control in unit of points.

getWorkbook()

Gets the Workbook object.

isAutoSize()

Indicates whether the control will automatically resize to display its entire contents.

isAutoWordSelected()

Specifies the basic unit used to extend a selection. True specifies that the basic unit is a single character. false specifies that the basic unit is a whole word.

isDragBehaviorEnabled()

Indicates whether dragging and dropping is enabled for the control.

isEditable()

Indicates whether the user can type into the control.

isEnabled()

Indicates whether the control can receive the focus and respond to user-generated events.

isLocked()

Indicates whether data in the control is locked for editing.

isTransparent()

Indicates whether the control is transparent.

isVisible()

Indicates whether this control is visible.

setAutoSize()

Indicates whether the control will automatically resize to display its entire contents.

setAutoWordSelected()

Specifies the basic unit used to extend a selection. True specifies that the basic unit is a single character. false specifies that the basic unit is a whole word.

setBackOleColor()

Gets and sets the ole color of the background.

setBorderOleColor()

Gets and sets the ole color of the background.

setBorderStyle()

Gets and set the type of border used by the control. The value of the property is ControlBorderType integer constant.

setBoundColumn()

Represents how the Value property is determined for a ComboBox or ListBox when the MultiSelect properties value (fmMultiSelectSingle).

setColumnCount()

Represents the number of columns to display in a ComboBox or ListBox.

setColumnWidths()

Gets and sets the width of the column.

setDragBehaviorEnabled()

Indicates whether dragging and dropping is enabled for the control.

setDropButtonStyle()

Specifies the symbol displayed on the drop button The value of the property is DropButtonStyle integer constant.

setEditable()

Indicates whether the user can type into the control.

setEnabled()

Indicates whether the control can receive the focus and respond to user-generated events.

setEnterFieldBehavior()

Specifies selection behavior when entering the control. True specifies that the selection remains unchanged from last time the control was active. False specifies that all the text in the control will be selected when entering the control.

setForeOleColor()

Gets and sets the ole color of the foreground. Not applies to Image control.

setHeight()

Gets and sets the height of the control in unit of points.

setHideSelection()

Indicates whether selected text in the control appears highlighted when the control does not have focus.

setIMEMode()

Gets and sets the default run-time mode of the Input Method Editor for the control as it receives focus. The value of the property is InputMethodEditorMode integer constant.

setLinkedCell()

Gets and sets the linked cell.

setListFillRange()

Gets and sets the list fill range.

setListRows()

Represents the maximum number of rows to display in the list.

setListStyle()

Gets and sets the visual appearance. The value of the property is ControlListStyle integer constant.

setListWidth()

Gets and set the width in unit of points.

setLocked()

Indicates whether data in the control is locked for editing.

setMatchEntry()

Indicates how a ListBox or ComboBox searches its list as the user types. The value of the property is ControlMatchEntryType integer constant.

setMaxLength()

Gets and sets the maximum number of characters

setMouseIcon()

Gets and sets a custom icon to display as the mouse pointer for the control.

setMousePointer()

Gets and sets the type of icon displayed as the mouse pointer for the control. The value of the property is ControlMousePointerType integer constant.

setSelectionMargin()

Indicates whether the user can select a line of text by clicking in the region to the left of the text.

setShadow()

Indicates whether to show a shadow.

setShowColumnHeads()

Indicates whether column headings are displayed.

setShowDropButtonTypeWhen()

Specifies the symbol displayed on the drop button The value of the property is ShowDropButtonType integer constant.

setSpecialEffect()

Gets and sets the special effect of the control. The value of the property is ControlSpecialEffectType integer constant.

setTextAlign()

Represents how to align the text used by the control. The value of the property is TextAlignmentType integer constant.

setTextColumn()

Represents the column in a ComboBox or ListBox to display to the user.

setTransparent()

Indicates whether the control is transparent.

setValue()

Gets and sets the value of the control.

setVisible()

Indicates whether this control is visible.

setWidth()

Gets and sets the width of the control in unit of points.