Sets the specified properties of a Shape. The Shape is created if it doesn't exist.
Overload Name | Description |
---|---|
BringForward | Bring a shape forward. |
BringToFront | Bring a shape to front. |
FlipHorizontal | Flip a shape horizontally. |
FlipVertical | Flip a shape vertically. |
General | Add or modify a shape. |
IncrementLeft | Increment the left position of a shape. |
IncrementTop | Increment the top position of a shape. |
Remove | Remove a shape. |
ScaleHeight | Scales a shape per the specified factor. |
ScaleWidth | Scales a shape per the specified factor. |
Select | Select a shape. |
SendBackward | Send a shape backwards. |
SendToBack | Send a shape to the back. |
Bring a shape 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 assigned to the Shape. This can be used to identify the shape after it is created. |
Bring a shape 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 assigned to the Shape. This can be used to identify the shape after it is created. |
Flip a shape 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 assigned to the Shape. This can be used to identify the shape after it is created. |
Flip a shape 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 assigned to the Shape. This can be used to identify the shape after it is created. |
Add or modify a shape.
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 assigned to the Shape. This can be used to identify the shape after it is created. |
Shape_ActionButtons |
Select a shape.
Specify one of the following values or an arbitrary value:
<blank> ActionButtonCustom ActionButtonHome ActionButtonHelp ActionButtonInformation ActionButtonBackorPrevious ActionButtonForwardorNext ActionButtonBeginning ActionButtonEnd ActionButtonReturn ActionButtonDocument ActionButtonSound ActionButtonMovie
|
Shape_Callouts |
Select a shape.
Specify one of the following values or an arbitrary value:
<blank> RectangularCallout RoundedRectangularCallout OvalCallout CloudCallout LineCallout1 LineCallout2 LineCallout3 LineCallout4 LineCallout1AccentBar LineCallout2AccentBar LineCallout3AccentBar LineCallout4AccentBar LineCallout1NoBorder LineCallout2NoBorder LineCallout3NoBorder LineCallout4NoBorder LineCallout1BorderandAccentBar LineCallout2BorderandAccentBar LineCallout3BorderandAccentBar LineCallout4BorderandAccentBar
|
Shape_BasicShapes |
Select a shape.
Specify one of the following values or an arbitrary value:
<blank> Rectangle Parallelogram Trapezoid Diamond RoundedRectangle Octagon IsoscelesTriangle RightTriangle Oval Hexagon Cross RegularPentagon Can Cube Bevel FoldedCorner SmileyFace Donut NoSymbol BlockArc Heart LightningBolt Sun Moon Arc DoubleBracket DoubleBrace Plaque LeftBracket RightBracket LeftBrace RightBrace Mixed Balloon NotPrimitive
|
Shape_BlockArrows |
Select a shape.
Specify one of the following values or an arbitrary value:
<blank> RightArrow LeftArrow UpArrow DownArrow LeftRightArrow UpDownArrow QuadArrow LeftRightUpArrow BentArrow UTurnArrow LeftUpArrow BentUpArrow CurvedRightArrow CurvedLeftArrow CurvedUpArrow CurvedDownArrow StripedRightArrow NotchedRightArrow Pentagon Chevron RightArrowCallout LeftArrowCallout UpArrowCallout DownArrowCallout LeftRightArrowCallout UpDownArrowCallout QuadArrowCallout CircularArrow
|
Shape_FlowchartShapes |
Select a shape.
Specify one of the following values or an arbitrary value:
<blank> FlowchartProcess FlowchartAlternateProcess FlowchartDecision FlowchartData FlowchartPredefinedProcess FlowchartInternalStorage FlowchartDocument FlowchartMultidocument FlowchartTerminator FlowchartPreparation FlowchartManualInput FlowchartManualOperation FlowchartConnector FlowchartOffpageConnector FlowchartCard FlowchartPunchedTape FlowchartSummingJunction FlowchartOr FlowchartCollate FlowchartSort FlowchartExtract FlowchartMerge FlowchartStoredData FlowchartDelay FlowchartSequentialAccessStorage FlowchartMagneticDisk FlowchartDirectAccessStorage FlowchartDisplay
|
Shape_StarsAndBanners |
Select a shape.
Specify one of the following values or an arbitrary value:
<blank> Explosion1 Explosion2 Star4Point Star5Point Star8Point Star16Point Star24Point Star32Point UpRibbon DownRibbon CurvedUpRibbon CurvedDownRibbon VerticalScroll HorizontalScroll Wave DoubleWave
|
OnClickProcedure | The name of the procedure to execute when the shape is clicked. |
OnDoubleClickProcedure | The name of the procedure to execute when the shape is double-clicked. |
Placement |
The placement behavior of the shape.
Specify one of the following values or an arbitrary value:
<blank> FreeFloating Move MoveAndSize
|
Column | The column to put the Shape 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 the will define the width of the shape. The Width argument can be used instead of this. |
ColumnPoints | The position of the left edge of the Shape in points. If used with the Column argument then the two are added together. |
Row | The row to put the Shape 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 shape. The Height argument can be used instead of this. |
RowPoints | The position of the top edge of the Shape in points. If used with the Row argument then the two are added together. |
Width | The width of the Shape in points. The EndColumn argument can be used instead of this. |
Height | The height of the Shape in points. The EndRow argument can be used instead of this. |
LockAspectRatio |
Whether the shape's aspect ratio is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Locked |
Whether the shape is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Visible |
Whether the shape is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintShape |
Whether to print the shape.
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 the fill back 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
|
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. |
Increment the left position of a shape.
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 assigned to the Shape. This can be used to identify the shape after it is created. |
Increment | Specifies the increment in points. |
Increment the top position of a shape.
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 assigned to the Shape. This can be used to identify the shape after it is created. |
Increment | Specifies the increment in points. |
Remove a shape.
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 assigned to the Shape. This can be used to identify the shape after it is created. |
Scales a shape 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 assigned to the Shape. This can be used to identify the shape after it is created. |
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 shape 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 assigned to the Shape. This can be used to identify the shape after it is created. |
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
|
Select a shape.
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 assigned to the Shape. This can be used to identify the shape after it is created. |
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 shape 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 assigned to the Shape. This can be used to identify the shape after it is created. |
Send a shape 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 assigned to the Shape. This can be used to identify the shape after it is created. |