オートシェープ関連 Tips

オートシェイプをVBAで作成する。　 下のような図形があります。 msoShape24pointStar msoShape4pointStar msoShape8pointStar msoShapeActionButtonBeginning msoShapeActionButtonDocument msoShapeActionButtonForwardorNext msoShapeActionButtonHome msoShapeActionButtonMovie msoShapeActionButtonSound msoShapeBalloon msoShapeBentUpArrow msoShapeBlockArc msoShapeChevron msoShapeCloudCallout msoShapeCube msoShapeCurvedDownRibbon msoShapeCurvedUpRibbon msoShapeDonut msoShapeDoubleBracket msoShapeDownArrow msoShapeDownRibbon msoShapeExplosion2 msoShapeFlowchartCard msoShapeFlowchartConnector msoShapeFlowchartDecision msoShapeFlowchartDisplay msoShapeFlowchartDocument msoShapeFlowchartExtract msoShapeFlowchartInternalStorage msoShapeFlowchartMagneticDisk msoShapeFlowchartManualInput msoShapeFlowchartManualOperation msoShapeFlowchartMerge msoShapeFlowchartMultidocument msoShapeFlowchartOffpageConnector msoShapeFlowchartOr msoShapeFlowchartPredefinedProcess msoShapeFlowchartPreparation msoShapeFlowchartProcess msoShapeFlowchartPunchedTape msoShapeFlowchartSequentialAccessStorage msoShapeFlowchartSort msoShapeFlowchartStoredData msoShapeFlowchartSummingJunction msoShapeFlowchartTerminator msoShapeFoldedCorner msoShapeHeart msoShapeHexagon msoShapeHorizontalScroll msoShapeIsoscelesTriangle msoShapeLeftArrow msoShapeLeftArrowCallout msoShapeLeftBrace msoShapeLeftBracket msoShapeLeftRightArrow msoShapeLeftRightArrowCallout msoShapeLeftRightUpArrow msoShapeLeftUpArrow msoShapeLightningBolt msoShapeLineCallout1 msoShapeLineCallout1BorderandAccentBar msoShapeLineCallout1NoBorder msoShapeLineCallout2 msoShapeLineCallout2AccentBar msoShapeLineCallout2BorderandAccentBar msoShapeLineCallout2NoBorder msoShapeLineCallout3 msoShapeLineCallout3AccentBar msoShapeLineCallout3BorderandAccentBar msoShapeLineCallout3NoBorder msoShapeLineCallout4 msoShapeLineCallout4AccentBar msoShapeLineCallout4BorderandAccentBar msoShapeLineCallout4NoBorder msoShapeMoon msoShapeNoSymbol msoShapeNotchedRightArrow msoShapeOctagon msoShapeOval msoShapeOvalCallout msoShapeParallelogram msoShapePentagon msoShapePlaque msoShapeQuadArrowCallout msoShapeRectangularCallout msoShapeRightArrow msoShapeRightBrace msoShapeRightTriangle msoShapeRoundedRectangularCallout msoShapeStripedRightArrow msoShapeTrapezoid msoShapeUpArrowCallout msoShapeUpDownArrowCallout msoShapeUTurnArrow msoShapeWave msoShape16pointStar msoShape32pointStar msoShape5pointStar msoShapeActionButtonBackorPrevious msoShapeActionButtonCustom msoShapeActionButtonEnd msoShapeActionButtonHelp msoShapeActionButtonInformation msoShapeActionButtonReturn msoShapeArc msoShapeBentArrow msoShapeBevel msoShapeCircularArrow msoShapeCross msoShapeCurvedDownArrow msoShapeCurvedLeftArrow msoShapeCurvedUpArrow msoShapeDiamond msoShapeDoubleBrace msoShapeDoubleWave msoShapeDownArrowCallout msoShapeExplosion1 msoShapeFlowchartAlternateProcess msoShapeFlowchartCollate msoShapeFlowchartData msoShapeFlowchartDelay msoShapeQuadArrow msoShapeRectangle msoShapeRegularPentagon msoShapeRightArrowCallout msoShapeRightBracket msoShapeRoundedRectangle msoShapeSmileyFace msoShapeSun msoShapeUpArrow msoShapeUpDownArrow msoShapeUpRibbon msoShapeVerticalScroll シェイプの位置・線色・塗りつぶしの色 等を設定 シェイプの文字・位置・色・サイズを設定 オートシェイプを作成し回転させる オートシェイプを作成後コピーし、GIF画像で貼り付け オートシェイプの名前を調べ削除する オートシェイプのクリックイベントでシェイプの名前を取得 オートシェイプの名前の付け方