Methods

getAccelerator()

Gets and sets the accelerator key for the control.

getAlignment()

Gets and set the position of the Caption relative to the control. The value of the property is ControlCaptionAlignmentType integer constant.

getBackOleColor()

Gets and sets the ole color of the background.

getCaption()

Gets and set the descriptive text that appears on a control.

getData()

Gets and sets the binary data of the control.

getFont()

Represents the font of the control.

getForeOleColor()

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

getGroupName()

Gets and sets the group's name.

getHeight()

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

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.

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.

getPicture()

Gets and sets the data of the picture.

getPicturePosition()

Gets and set the location of the control's picture relative to its caption. The value of the property is ControlPicturePositionType integer constant.

getShadow()

Indicates whether to show a shadow.

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.

getType()

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

getValue()

Indicates if the control is checked or not. The value of the property is CheckValueType integer constant.

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.

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.

isTripleState()

Indicates how the specified control will display Null values. SettingDescriptionTrueThe control will cycle through states for Yes, No, and Null values. The control appears dimmed (grayed) when its Value property is set to Null.False(Default) The control will cycle through states for Yes and No values. Null values display as if they were No values.

isVisible()

Indicates whether this control is visible.

isWordWrapped()

Indicates whether the contents of the control automatically wrap at the end of a line.

setAccelerator()

Gets and sets the accelerator key for the control.

setAlignment()

Gets and set the position of the Caption relative to the control. The value of the property is ControlCaptionAlignmentType integer constant.

setAutoSize()

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

setBackOleColor()

Gets and sets the ole color of the background.

setCaption()

Gets and set the descriptive text that appears on a control.

setEnabled()

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

setForeOleColor()

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

setGroupName()

Gets and sets the group's name.

setHeight()

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

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.

setLocked()

Indicates whether data in the control is locked for editing.

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.

setPicture()

Gets and sets the data of the picture.

setPicturePosition()

Gets and set the location of the control's picture relative to its caption. The value of the property is ControlPicturePositionType integer constant.

setShadow()

Indicates whether to show a shadow.

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.

setTransparent()

Indicates whether the control is transparent.

setTripleState()

Indicates how the specified control will display Null values. SettingDescriptionTrueThe control will cycle through states for Yes, No, and Null values. The control appears dimmed (grayed) when its Value property is set to Null.False(Default) The control will cycle through states for Yes and No values. Null values display as if they were No values.

setValue()

Indicates if the control is checked or not. The value of the property is CheckValueType integer constant.

setVisible()

Indicates whether this control is visible.

setWidth()

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

setWordWrapped()

Indicates whether the contents of the control automatically wrap at the end of a line.