Creates the specified Control if it doesn't exist, and sets the specified properties of it.
Overload Name | Description |
---|---|
AddItem | Add an item to the list of a drop-down or list-box control. |
BringForward | Bring a control forward. |
BringToFront | Bring a control to front. |
Button | Add or modify a Button control. |
CheckBox | Add or modify a CheckBox control. |
DropDown | Add or modify a DropDown control. |
FlipHorizontal | Flip a control horizontally. |
FlipVertical | Flip a control vertically. |
IncrementLeft | Increment the left position of a control. |
IncrementTop | Increment the top position of a control. |
Label | Add or modify a Label control. |
ListBox | Add or modify a ListBox control. |
Remove | Remove a control. |
RemoveAllItems | Remove all items from a drop-down or list-box control's list. If the control's list is linked to a range then the link is removed. |
RemoveItem | Remove an item from a drop-down or list-box control's list. Does nothing if the control's list is linked to a range. |
ScaleHeight | Scales a control per the specified factor. |
ScaleWidth | Scales a control per the specified factor. |
ScrollBar | Add or modify a ScrollBar control. |
Select | Select a control. |
SendBackward | Send a control backwards. |
SendToBack | Send a control to the back. |
Spinner | Add or modify a Spinner control. |
Add an item to the list of a drop-down or list-box control.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
ItemText | For the AddItem overload, the text of the item to be added. For the RemoveItem overload, either the ListIndex or the ItemText can be used to indicate the item to be removed. If both are specified, the ListIndex is used. |
ListIndex | The index of the selected item in the control's list. |
Bring a control forward.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
Bring a control to front.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
Add or modify a Button control.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
Text | The text. |
OnClickProcedure |
The name of the procedure to execute when the control is clicked. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
OnDoubleClickProcedure |
The name of the procedure to execute when the control is double-clicked. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
Placement |
The placement behavior of the chart. FreeFloating: Do not move with cells. Move: Do not move with cells. MoveAndSize: Move and size with cells.
Specify one of the following values or an arbitrary value:
<blank> FreeFloating Move MoveAndSize
|
Column | The column to put the Control into. 0.0 is the left edge of the first column. 0.5 is the middle of the first column, etc. If used with the ColumnPoints argument then the two are added together. |
EndColumn | The column that will define the width of the control. The Width argument can be used instead of EndColumn. |
ColumnPoints | The position of the left edge of the Control in points. If used with the Column argument then the two are added together. |
Row | The row to put the Control into. 0.0 is the top edge of the first row. 0.5 is the middle of the first row, etc. If used with the RowPoints argument then the two are added together. |
EndRow | The row the will define the height of the control. The Height argument can be used instead of EndRow. |
RowPoints | The position of the top edge of the Control in points. If used with the Row argument then the two are added together. |
Width | The width of the Control in points. The EndColumn argument can be used instead of this argument. |
Height | The height of the Control in points. The EndRow argument can be used instead of this argument. |
LockAspectRatio |
Whether the control's aspect ratio is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Locked |
Whether the control is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Visible |
Whether the control is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintControl |
Whether to print the control.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FillBackColor | Select the fill back color. |
FillBackColorIndex |
Excel color palette index to use for fill background color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FillForeColor | Select the fill forecolor. |
FillForeColorIndex |
Excel color palette index to use for the fill forecolor. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FillTransparency | From 0.0 to 1.0 (opaque to transparent). |
FillVisible |
Whether the fill is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontBold |
Whether font is bold.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontColor | Select the font color. |
FontColorIndex |
Excel color palette index to use for the font color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FontItalic |
Wether the font is italicized.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontName | Select a font. |
FontOutlineFont |
Whether the font has the outline effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontShadow |
Whether the font has the shadow effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSize | The font size, in points. |
FontStrikethrough |
Whether the font has the strikethrough effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSubscript |
Whether the font has the subscript effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSuperscript |
Whether the font has the superscript effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontUnderline |
Whether the font has the underline effect.
Specify one of the following values or an arbitrary value:
<blank> None Single Double SingleAccounting DoubleAccounting
|
BorderColor | Select the color for the line forecolor. |
BorderColorIndex |
Excel color palette index to use for the line forecolor. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
BorderTransparency | From 0.0 to 1.0 (opaque to transparent). |
BorderVisible |
Whether the line is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
BorderWeight | The weight of the line, in points. |
TextAutoSize |
Whether the size of the text box will increase to display all of the text.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TextHorizontalAlignment |
The horizontal alignment.
Specify one of the following values or an arbitrary value:
<blank> General Left Center Right Fill Justify CenterAcrossSelection Distributed
|
TextLockText |
Whether text will be locked when sheet protection is enabled.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TextMarginBottom | The bottom margin of this text box in points. |
TextMarginLeft | The left margin of this text box in points. |
TextMarginRight | The right margin of this text box in points. |
TextMarginTop | The top margin of this text box in points. |
TextOrientation |
The orientation of the text.
Specify one of the following values or an arbitrary value:
<blank> Mixed Horizontal VerticalFarEast Upward Downward HorizontalRotatedFarEast Vertical
|
TextVerticalAlignment |
The vertical alignment.
Specify one of the following values or an arbitrary value:
<blank> Top Center Bottom Justify Distributed
|
Add or modify a CheckBox control.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
Text | The text. |
Value | The Value to assign to the control. Control values are always numeric. |
OnCheckStateChangedProcedure |
The name of the procedure to execute when the state of a checkbox changes. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
OnClickProcedure |
The name of the procedure to execute when the control is clicked. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
OnDoubleClickProcedure |
The name of the procedure to execute when the control is double-clicked. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
OnValueChangedProcedure |
The name of the procedure to execute when the value of the control changes. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
LinkedCell | The address of a cell that will be linked to the value of the control. |
Placement |
The placement behavior of the chart. FreeFloating: Do not move with cells. Move: Do not move with cells. MoveAndSize: Move and size with cells.
Specify one of the following values or an arbitrary value:
<blank> FreeFloating Move MoveAndSize
|
Column | The column to put the Control into. 0.0 is the left edge of the first column. 0.5 is the middle of the first column, etc. If used with the ColumnPoints argument then the two are added together. |
EndColumn | The column that will define the width of the control. The Width argument can be used instead of EndColumn. |
ColumnPoints | The position of the left edge of the Control in points. If used with the Column argument then the two are added together. |
Row | The row to put the Control into. 0.0 is the top edge of the first row. 0.5 is the middle of the first row, etc. If used with the RowPoints argument then the two are added together. |
EndRow | The row the will define the height of the control. The Height argument can be used instead of EndRow. |
RowPoints | The position of the top edge of the Control in points. If used with the Row argument then the two are added together. |
Width | The width of the Control in points. The EndColumn argument can be used instead of this argument. |
Height | The height of the Control in points. The EndRow argument can be used instead of this argument. |
LockAspectRatio |
Whether the control's aspect ratio is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Locked |
Whether the control is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Visible |
Whether the control is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintControl |
Whether to print the control.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FillBackColor | Select the fill back color. |
FillBackColorIndex |
Excel color palette index to use for fill background color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FillForeColor | Select the fill forecolor. |
FillForeColorIndex |
Excel color palette index to use for the fill forecolor. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FillTransparency | From 0.0 to 1.0 (opaque to transparent). |
FillVisible |
Whether the fill is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontBold |
Whether font is bold.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontColor | Select the font color. |
FontColorIndex |
Excel color palette index to use for the font color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FontItalic |
Wether the font is italicized.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontName | Select a font. |
FontOutlineFont |
Whether the font has the outline effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontShadow |
Whether the font has the shadow effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSize | The font size, in points. |
FontStrikethrough |
Whether the font has the strikethrough effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSubscript |
Whether the font has the subscript effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSuperscript |
Whether the font has the superscript effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontUnderline |
Whether the font has the underline effect.
Specify one of the following values or an arbitrary value:
<blank> None Single Double SingleAccounting DoubleAccounting
|
BorderColor | Select the color for the line forecolor. |
BorderColorIndex |
Excel color palette index to use for the line forecolor. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
BorderTransparency | From 0.0 to 1.0 (opaque to transparent). |
BorderVisible |
Whether the line is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
BorderWeight | The weight of the line, in points. |
TextAutoSize |
Whether the size of the text box will increase to display all of the text.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TextHorizontalAlignment |
The horizontal alignment.
Specify one of the following values or an arbitrary value:
<blank> General Left Center Right Fill Justify CenterAcrossSelection Distributed
|
TextLockText |
Whether text will be locked when sheet protection is enabled.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TextMarginBottom | The bottom margin of this text box in points. |
TextMarginLeft | The left margin of this text box in points. |
TextMarginRight | The right margin of this text box in points. |
TextMarginTop | The top margin of this text box in points. |
TextOrientation |
The orientation of the text.
Specify one of the following values or an arbitrary value:
<blank> Mixed Horizontal VerticalFarEast Upward Downward HorizontalRotatedFarEast Vertical
|
TextVerticalAlignment |
The vertical alignment.
Specify one of the following values or an arbitrary value:
<blank> Top Center Bottom Justify Distributed
|
Add or modify a DropDown control.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
ItemsList | A semicolon delimited list of items to add to the control. |
Text | The text. |
DropDownLines | Specifies the number of items to display at one time in a dropdown. |
Value | The Value to assign to the control. Control values are always numeric. |
ValueText | The text of the item to select. |
OnClickProcedure |
The name of the procedure to execute when the control is clicked. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
OnDoubleClickProcedure |
The name of the procedure to execute when the control is double-clicked. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
OnSelectedIndexChangedProcedure |
The name of the procedure to execute when the selected item of the control changes. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
OnTextChangedProcedure |
The name of the procedure to execute when the text of the control changes. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
OnValueChangedProcedure |
The name of the procedure to execute when the value of the control changes. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
LinkedCell | The address of a cell that will be linked to the value of the control. |
ListFillRange | The address of a range that will be used to populate the list of the control. |
ListIndex | The index of the selected item in the control's list. |
Placement |
The placement behavior of the chart. FreeFloating: Do not move with cells. Move: Do not move with cells. MoveAndSize: Move and size with cells.
Specify one of the following values or an arbitrary value:
<blank> FreeFloating Move MoveAndSize
|
Column | The column to put the Control into. 0.0 is the left edge of the first column. 0.5 is the middle of the first column, etc. If used with the ColumnPoints argument then the two are added together. |
EndColumn | The column that will define the width of the control. The Width argument can be used instead of EndColumn. |
ColumnPoints | The position of the left edge of the Control in points. If used with the Column argument then the two are added together. |
Row | The row to put the Control into. 0.0 is the top edge of the first row. 0.5 is the middle of the first row, etc. If used with the RowPoints argument then the two are added together. |
EndRow | The row the will define the height of the control. The Height argument can be used instead of EndRow. |
RowPoints | The position of the top edge of the Control in points. If used with the Row argument then the two are added together. |
Width | The width of the Control in points. The EndColumn argument can be used instead of this argument. |
Height | The height of the Control in points. The EndRow argument can be used instead of this argument. |
LockAspectRatio |
Whether the control's aspect ratio is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Locked |
Whether the control is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Visible |
Whether the control is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintControl |
Whether to print the control.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FillBackColor | Select the fill back color. |
FillBackColorIndex |
Excel color palette index to use for fill background color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FillForeColor | Select the fill forecolor. |
FillForeColorIndex |
Excel color palette index to use for the fill forecolor. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FillTransparency | From 0.0 to 1.0 (opaque to transparent). |
FillVisible |
Whether the fill is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontBold |
Whether font is bold.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontColor | Select the font color. |
FontColorIndex |
Excel color palette index to use for the font color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FontItalic |
Wether the font is italicized.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontName | Select a font. |
FontOutlineFont |
Whether the font has the outline effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontShadow |
Whether the font has the shadow effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSize | The font size, in points. |
FontStrikethrough |
Whether the font has the strikethrough effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSubscript |
Whether the font has the subscript effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSuperscript |
Whether the font has the superscript effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontUnderline |
Whether the font has the underline effect.
Specify one of the following values or an arbitrary value:
<blank> None Single Double SingleAccounting DoubleAccounting
|
BorderColor | Select the color for the line forecolor. |
BorderColorIndex |
Excel color palette index to use for the line forecolor. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
BorderTransparency | From 0.0 to 1.0 (opaque to transparent). |
BorderVisible |
Whether the line is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
BorderWeight | The weight of the line, in points. |
TextAutoSize |
Whether the size of the text box will increase to display all of the text.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TextHorizontalAlignment |
The horizontal alignment.
Specify one of the following values or an arbitrary value:
<blank> General Left Center Right Fill Justify CenterAcrossSelection Distributed
|
TextLockText |
Whether text will be locked when sheet protection is enabled.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TextMarginBottom | The bottom margin of this text box in points. |
TextMarginLeft | The left margin of this text box in points. |
TextMarginRight | The right margin of this text box in points. |
TextMarginTop | The top margin of this text box in points. |
TextOrientation |
The orientation of the text.
Specify one of the following values or an arbitrary value:
<blank> Mixed Horizontal VerticalFarEast Upward Downward HorizontalRotatedFarEast Vertical
|
TextVerticalAlignment |
The vertical alignment.
Specify one of the following values or an arbitrary value:
<blank> Top Center Bottom Justify Distributed
|
Flip a control horizontally.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
Flip a control vertically.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
Increment the left position of a control.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
Increment | Specifies the increment in points. |
Increment the top position of a control.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
Increment | Specifies the increment in points. |
Add or modify a Label control.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
Text | The text. |
OnClickProcedure |
The name of the procedure to execute when the control is clicked. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
OnDoubleClickProcedure |
The name of the procedure to execute when the control is double-clicked. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
Placement |
The placement behavior of the chart. FreeFloating: Do not move with cells. Move: Do not move with cells. MoveAndSize: Move and size with cells.
Specify one of the following values or an arbitrary value:
<blank> FreeFloating Move MoveAndSize
|
Column | The column to put the Control into. 0.0 is the left edge of the first column. 0.5 is the middle of the first column, etc. If used with the ColumnPoints argument then the two are added together. |
EndColumn | The column that will define the width of the control. The Width argument can be used instead of EndColumn. |
ColumnPoints | The position of the left edge of the Control in points. If used with the Column argument then the two are added together. |
Row | The row to put the Control into. 0.0 is the top edge of the first row. 0.5 is the middle of the first row, etc. If used with the RowPoints argument then the two are added together. |
EndRow | The row the will define the height of the control. The Height argument can be used instead of EndRow. |
RowPoints | The position of the top edge of the Control in points. If used with the Row argument then the two are added together. |
Width | The width of the Control in points. The EndColumn argument can be used instead of this argument. |
Height | The height of the Control in points. The EndRow argument can be used instead of this argument. |
LockAspectRatio |
Whether the control's aspect ratio is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Locked |
Whether the control is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Visible |
Whether the control is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintControl |
Whether to print the control.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FillBackColor | Select the fill back color. |
FillBackColorIndex |
Excel color palette index to use for fill background color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FillForeColor | Select the fill forecolor. |
FillForeColorIndex |
Excel color palette index to use for the fill forecolor. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FillTransparency | From 0.0 to 1.0 (opaque to transparent). |
FillVisible |
Whether the fill is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontBold |
Whether font is bold.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontColor | Select the font color. |
FontColorIndex |
Excel color palette index to use for the font color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FontItalic |
Wether the font is italicized.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontName | Select a font. |
FontOutlineFont |
Whether the font has the outline effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontShadow |
Whether the font has the shadow effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSize | The font size, in points. |
FontStrikethrough |
Whether the font has the strikethrough effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSubscript |
Whether the font has the subscript effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSuperscript |
Whether the font has the superscript effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontUnderline |
Whether the font has the underline effect.
Specify one of the following values or an arbitrary value:
<blank> None Single Double SingleAccounting DoubleAccounting
|
BorderColor | Select the color for the line forecolor. |
BorderColorIndex |
Excel color palette index to use for the line forecolor. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
BorderTransparency | From 0.0 to 1.0 (opaque to transparent). |
BorderVisible |
Whether the line is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
BorderWeight | The weight of the line, in points. |
TextAutoSize |
Whether the size of the text box will increase to display all of the text.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TextHorizontalAlignment |
The horizontal alignment.
Specify one of the following values or an arbitrary value:
<blank> General Left Center Right Fill Justify CenterAcrossSelection Distributed
|
TextLockText |
Whether text will be locked when sheet protection is enabled.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TextMarginBottom | The bottom margin of this text box in points. |
TextMarginLeft | The left margin of this text box in points. |
TextMarginRight | The right margin of this text box in points. |
TextMarginTop | The top margin of this text box in points. |
TextOrientation |
The orientation of the text.
Specify one of the following values or an arbitrary value:
<blank> Mixed Horizontal VerticalFarEast Upward Downward HorizontalRotatedFarEast Vertical
|
TextVerticalAlignment |
The vertical alignment.
Specify one of the following values or an arbitrary value:
<blank> Top Center Bottom Justify Distributed
|
Add or modify a ListBox control.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
ItemsList | A semicolon delimited list of items to add to the control. |
Text | The text. |
Value | The Value to assign to the control. Control values are always numeric. |
ValueText | The text of the item to select. |
OnClickProcedure |
The name of the procedure to execute when the control is clicked. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
OnDoubleClickProcedure |
The name of the procedure to execute when the control is double-clicked. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
OnSelectedIndexChangedProcedure |
The name of the procedure to execute when the selected item of the control changes. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
OnTextChangedProcedure |
The name of the procedure to execute when the text of the control changes. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
OnValueChangedProcedure |
The name of the procedure to execute when the value of the control changes. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
LinkedCell | The address of a cell that will be linked to the value of the control. |
ListFillRange | The address of a range that will be used to populate the list of the control. |
ListIndex | The index of the selected item in the control's list. |
Placement |
The placement behavior of the chart. FreeFloating: Do not move with cells. Move: Do not move with cells. MoveAndSize: Move and size with cells.
Specify one of the following values or an arbitrary value:
<blank> FreeFloating Move MoveAndSize
|
Column | The column to put the Control into. 0.0 is the left edge of the first column. 0.5 is the middle of the first column, etc. If used with the ColumnPoints argument then the two are added together. |
EndColumn | The column that will define the width of the control. The Width argument can be used instead of EndColumn. |
ColumnPoints | The position of the left edge of the Control in points. If used with the Column argument then the two are added together. |
Row | The row to put the Control into. 0.0 is the top edge of the first row. 0.5 is the middle of the first row, etc. If used with the RowPoints argument then the two are added together. |
EndRow | The row the will define the height of the control. The Height argument can be used instead of EndRow. |
RowPoints | The position of the top edge of the Control in points. If used with the Row argument then the two are added together. |
Width | The width of the Control in points. The EndColumn argument can be used instead of this argument. |
Height | The height of the Control in points. The EndRow argument can be used instead of this argument. |
LockAspectRatio |
Whether the control's aspect ratio is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Locked |
Whether the control is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Visible |
Whether the control is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintControl |
Whether to print the control.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FillBackColor | Select the fill back color. |
FillBackColorIndex |
Excel color palette index to use for fill background color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FillForeColor | Select the fill forecolor. |
FillForeColorIndex |
Excel color palette index to use for the fill forecolor. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FillTransparency | From 0.0 to 1.0 (opaque to transparent). |
FillVisible |
Whether the fill is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontBold |
Whether font is bold.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontColor | Select the font color. |
FontColorIndex |
Excel color palette index to use for the font color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FontItalic |
Wether the font is italicized.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontName | Select a font. |
FontOutlineFont |
Whether the font has the outline effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontShadow |
Whether the font has the shadow effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSize | The font size, in points. |
FontStrikethrough |
Whether the font has the strikethrough effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSubscript |
Whether the font has the subscript effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSuperscript |
Whether the font has the superscript effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontUnderline |
Whether the font has the underline effect.
Specify one of the following values or an arbitrary value:
<blank> None Single Double SingleAccounting DoubleAccounting
|
BorderColor | Select the color for the line forecolor. |
BorderColorIndex |
Excel color palette index to use for the line forecolor. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
BorderTransparency | From 0.0 to 1.0 (opaque to transparent). |
BorderVisible |
Whether the line is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
BorderWeight | The weight of the line, in points. |
TextAutoSize |
Whether the size of the text box will increase to display all of the text.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TextHorizontalAlignment |
The horizontal alignment.
Specify one of the following values or an arbitrary value:
<blank> General Left Center Right Fill Justify CenterAcrossSelection Distributed
|
TextLockText |
Whether text will be locked when sheet protection is enabled.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TextMarginBottom | The bottom margin of this text box in points. |
TextMarginLeft | The left margin of this text box in points. |
TextMarginRight | The right margin of this text box in points. |
TextMarginTop | The top margin of this text box in points. |
TextOrientation |
The orientation of the text.
Specify one of the following values or an arbitrary value:
<blank> Mixed Horizontal VerticalFarEast Upward Downward HorizontalRotatedFarEast Vertical
|
TextVerticalAlignment |
The vertical alignment.
Specify one of the following values or an arbitrary value:
<blank> Top Center Bottom Justify Distributed
|
Remove a control.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
Remove all items from a drop-down or list-box control's list. If the control's list is linked to a range then the link is removed.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
Remove an item from a drop-down or list-box control's list. Does nothing if the control's list is linked to a range.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
ItemText | For the AddItem overload, the text of the item to be added. For the RemoveItem overload, either the ListIndex or the ItemText can be used to indicate the item to be removed. If both are specified, the ListIndex is used. |
ListIndex | The index of the selected item in the control's list. |
Count | The number of items to remove. |
Scales a control per the specified factor.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
Factor | Specifies the factor by which to scale the original or current size. |
UseOriginalSize |
Whether the original or current as the starting size.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
ScaleFromPosition |
Whether the size should be scaled from the top-left, middle or bottom-right of the shape.
Specify one of the following values or an arbitrary value:
<blank> TopLeft Middle BottomRight
|
Scales a control per the specified factor.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
Factor | Specifies the factor by which to scale the original or current size. |
UseOriginalSize |
Whether the original or current as the starting size.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
ScaleFromPosition |
Whether the size should be scaled from the top-left, middle or bottom-right of the shape.
Specify one of the following values or an arbitrary value:
<blank> TopLeft Middle BottomRight
|
Add or modify a ScrollBar control.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
Text | The text. |
Value | The Value to assign to the control. Control values are always numeric. |
OnClickProcedure |
The name of the procedure to execute when the control is clicked. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
OnDoubleClickProcedure |
The name of the procedure to execute when the control is double-clicked. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
OnValueChangedProcedure |
The name of the procedure to execute when the value of the control changes. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
LinkedCell | The address of a cell that will be linked to the value of the control. |
LargeChange | The large change amount for a scrollbar control. |
Max | The maximum value for a scrollbar or spinner control. |
Min | The minimum value for a scrollbar or spinner control. |
SmallChange | The small change amount for a scrollbar or spinner control. |
Placement |
The placement behavior of the chart. FreeFloating: Do not move with cells. Move: Do not move with cells. MoveAndSize: Move and size with cells.
Specify one of the following values or an arbitrary value:
<blank> FreeFloating Move MoveAndSize
|
Column | The column to put the Control into. 0.0 is the left edge of the first column. 0.5 is the middle of the first column, etc. If used with the ColumnPoints argument then the two are added together. |
EndColumn | The column that will define the width of the control. The Width argument can be used instead of EndColumn. |
ColumnPoints | The position of the left edge of the Control in points. If used with the Column argument then the two are added together. |
Row | The row to put the Control into. 0.0 is the top edge of the first row. 0.5 is the middle of the first row, etc. If used with the RowPoints argument then the two are added together. |
EndRow | The row the will define the height of the control. The Height argument can be used instead of EndRow. |
RowPoints | The position of the top edge of the Control in points. If used with the Row argument then the two are added together. |
Width | The width of the Control in points. The EndColumn argument can be used instead of this argument. |
Height | The height of the Control in points. The EndRow argument can be used instead of this argument. |
LockAspectRatio |
Whether the control's aspect ratio is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Locked |
Whether the control is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Visible |
Whether the control is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintControl |
Whether to print the control.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FillBackColor | Select the fill back color. |
FillBackColorIndex |
Excel color palette index to use for fill background color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FillForeColor | Select the fill forecolor. |
FillForeColorIndex |
Excel color palette index to use for the fill forecolor. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FillTransparency | From 0.0 to 1.0 (opaque to transparent). |
FillVisible |
Whether the fill is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontBold |
Whether font is bold.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontColor | Select the font color. |
FontColorIndex |
Excel color palette index to use for the font color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FontItalic |
Wether the font is italicized.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontName | Select a font. |
FontOutlineFont |
Whether the font has the outline effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontShadow |
Whether the font has the shadow effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSize | The font size, in points. |
FontStrikethrough |
Whether the font has the strikethrough effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSubscript |
Whether the font has the subscript effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSuperscript |
Whether the font has the superscript effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontUnderline |
Whether the font has the underline effect.
Specify one of the following values or an arbitrary value:
<blank> None Single Double SingleAccounting DoubleAccounting
|
BorderColor | Select the color for the line forecolor. |
BorderColorIndex |
Excel color palette index to use for the line forecolor. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
BorderTransparency | From 0.0 to 1.0 (opaque to transparent). |
BorderVisible |
Whether the line is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
BorderWeight | The weight of the line, in points. |
TextAutoSize |
Whether the size of the text box will increase to display all of the text.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TextHorizontalAlignment |
The horizontal alignment.
Specify one of the following values or an arbitrary value:
<blank> General Left Center Right Fill Justify CenterAcrossSelection Distributed
|
TextLockText |
Whether text will be locked when sheet protection is enabled.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TextMarginBottom | The bottom margin of this text box in points. |
TextMarginLeft | The left margin of this text box in points. |
TextMarginRight | The right margin of this text box in points. |
TextMarginTop | The top margin of this text box in points. |
TextOrientation |
The orientation of the text.
Specify one of the following values or an arbitrary value:
<blank> Mixed Horizontal VerticalFarEast Upward Downward HorizontalRotatedFarEast Vertical
|
TextVerticalAlignment |
The vertical alignment.
Specify one of the following values or an arbitrary value:
<blank> Top Center Bottom Justify Distributed
|
Select a control.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
Replace |
Whether to replace the current selection of shapes, or add this shape to the selections.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Send a control backwards.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
Send a control to the back.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
Add or modify a Spinner control.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Name | The name of the Control. |
Text | The text. |
Value | The Value to assign to the control. Control values are always numeric. |
OnClickProcedure |
The name of the procedure to execute when the control is clicked. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
OnDoubleClickProcedure |
The name of the procedure to execute when the control is double-clicked. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
OnValueChangedProcedure |
The name of the procedure to execute when the value of the control changes. When multiple controls are added by calling the method from within a loop, you can use @EPVal(ControlName) to get the name of the affected control from within the executed procedure. |
LinkedCell | The address of a cell that will be linked to the value of the control. |
Max | The maximum value for a scrollbar or spinner control. |
Min | The minimum value for a scrollbar or spinner control. |
SmallChange | The small change amount for a scrollbar or spinner control. |
Placement |
The placement behavior of the chart. FreeFloating: Do not move with cells. Move: Do not move with cells. MoveAndSize: Move and size with cells.
Specify one of the following values or an arbitrary value:
<blank> FreeFloating Move MoveAndSize
|
Column | The column to put the Control into. 0.0 is the left edge of the first column. 0.5 is the middle of the first column, etc. If used with the ColumnPoints argument then the two are added together. |
EndColumn | The column that will define the width of the control. The Width argument can be used instead of EndColumn. |
ColumnPoints | The position of the left edge of the Control in points. If used with the Column argument then the two are added together. |
Row | The row to put the Control into. 0.0 is the top edge of the first row. 0.5 is the middle of the first row, etc. If used with the RowPoints argument then the two are added together. |
EndRow | The row the will define the height of the control. The Height argument can be used instead of EndRow. |
RowPoints | The position of the top edge of the Control in points. If used with the Row argument then the two are added together. |
Width | The width of the Control in points. The EndColumn argument can be used instead of this argument. |
Height | The height of the Control in points. The EndRow argument can be used instead of this argument. |
LockAspectRatio |
Whether the control's aspect ratio is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Locked |
Whether the control is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Visible |
Whether the control is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintControl |
Whether to print the control.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FillBackColor | Select the fill back color. |
FillBackColorIndex |
Excel color palette index to use for fill background color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FillForeColor | Select the fill forecolor. |
FillForeColorIndex |
Excel color palette index to use for the fill forecolor. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FillTransparency | From 0.0 to 1.0 (opaque to transparent). |
FillVisible |
Whether the fill is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontBold |
Whether font is bold.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontColor | Select the font color. |
FontColorIndex |
Excel color palette index to use for the font color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FontItalic |
Wether the font is italicized.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontName | Select a font. |
FontOutlineFont |
Whether the font has the outline effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontShadow |
Whether the font has the shadow effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSize | The font size, in points. |
FontStrikethrough |
Whether the font has the strikethrough effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSubscript |
Whether the font has the subscript effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSuperscript |
Whether the font has the superscript effect.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontUnderline |
Whether the font has the underline effect.
Specify one of the following values or an arbitrary value:
<blank> None Single Double SingleAccounting DoubleAccounting
|
BorderColor | Select the color for the line forecolor. |
BorderColorIndex |
Excel color palette index to use for the line forecolor. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
BorderTransparency | From 0.0 to 1.0 (opaque to transparent). |
BorderVisible |
Whether the line is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
BorderWeight | The weight of the line, in points. |
TextAutoSize |
Whether the size of the text box will increase to display all of the text.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TextHorizontalAlignment |
The horizontal alignment.
Specify one of the following values or an arbitrary value:
<blank> General Left Center Right Fill Justify CenterAcrossSelection Distributed
|
TextLockText |
Whether text will be locked when sheet protection is enabled.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TextMarginBottom | The bottom margin of this text box in points. |
TextMarginLeft | The left margin of this text box in points. |
TextMarginRight | The right margin of this text box in points. |
TextMarginTop | The top margin of this text box in points. |
TextOrientation |
The orientation of the text.
Specify one of the following values or an arbitrary value:
<blank> Mixed Horizontal VerticalFarEast Upward Downward HorizontalRotatedFarEast Vertical
|
TextVerticalAlignment |
The vertical alignment.
Specify one of the following values or an arbitrary value:
<blank> Top Center Bottom Justify Distributed
|