名称 | 值 | Description |
msoShape10pointStar | 149 | 10 磅星 |
msoShape12pointStar | 150 | 12 磅星 |
msoShape16pointStar | 94 | 16 磅星 |
msoShape24pointStar | 95 | 24 磅星 |
msoShape32pointStar | 96 | 32 磅星 |
msoShape4pointStar | 91 | 4 磅星 |
msoShape5pointStar | 92 | 5 磅星 |
msoShape6pointStar | 147 | 6 磅星 |
msoShape7pointStar | 148 | 7 磅星 |
msoShape8pointStar | 93 | 8 磅星 |
msoShapeActionButtonBackorPrevious | 129 | “后退”或“上一个”按钮。 支持鼠标单击和鼠标移过操作。 |
msoShapeActionButtonBeginning | 131 | “开始”按钮。 支持鼠标单击和鼠标移过操作。 |
msoShapeActionButtonCustom | 125 | 不带默认图片或文本的按钮。 支持鼠标单击和鼠标移过操作。 |
msoShapeActionButtonDocument | 134 | “文档”按钮。 支持鼠标单击和鼠标移过操作。 |
msoShapeActionButtonEnd | 132 | “结束”按钮。 支持鼠标单击和鼠标移过操作。 |
msoShapeActionButtonForwardorNext | 130 | “前进”或“下一个”按钮。 支持鼠标单击和鼠标移过操作。 |
msoShapeActionButtonHelp | 127 | 帮助按钮。 支持鼠标单击和鼠标移过操作。 |
msoShapeActionButtonHome | 126 | “主页”按钮。 支持鼠标单击和鼠标移过操作。 |
msoShapeActionButtonInformation | 128 | “信息”按钮。 支持鼠标单击和鼠标移过操作。 |
msoShapeActionButtonMovie | 136 | “影片”按钮。 支持鼠标单击和鼠标移过操作。 |
msoShapeActionButtonReturn | 133 | “返回”按钮。 支持鼠标单击和鼠标移过操作。 |
msoShapeActionButtonSound | 135 | “声音”按钮。 支持鼠标单击和鼠标移过操作。 |
msoShapeArc | 25 | 弧 |
msoShapeBalloon | 137 | 气球 |
msoShapeBentArrow | 41 | 带 90 度圆角的箭头。 |
msoShapeBentUpArrow | 44 | 带 90 度直角的箭头。 默认情况下上指。 |
msoShapeBevel | 15 | 棱台效果 |
msoShapeBlockArc | 20 | 块弧 |
msoShapeCan | 13 | 可以 |
msoShapeChartPlus | 182 | 正方形垂直和水平分为四个季度 |
msoShapeChartStar | 181 | 正方形沿垂直线和对角线分为六个部分 |
msoShapeChartX | 180 | 正方形沿对角线分为四部分 |
msoShapeChevron | 52 | 雪 佛 龙 |
msoShapeChord | 161 | 圆圈,用一条线连接两个点的外围通过圆的内部;带和弦的圆 |
msoShapeCircularArrow | 60 | 曲线 180 度角后面的方块箭头 |
msoShapeCloud | 179 | 云形状 |
msoShapeCloudCallout | 108 | 云标注 |
msoShapeCorner | 162 | 带矩形孔的矩形。 |
msoShapeCornerTabs | 169 | 沿矩形路径对齐的四个右三角形;四个“被砍”的角落。 |
msoShapeCross | 11 | 十字形 |
msoShapeCube | 14 | 立方体 |
msoShapeCurvedDownArrow | 48 | 向下弯曲的方块箭头 |
msoShapeCurvedDownRibbon | 100 | 向下弯曲的功能区横幅 |
msoShapeCurvedLeftArrow | 46 | 向左弯曲的方块箭头 |
msoShapeCurvedRightArrow | 45 | 向右弯曲的方块箭头 |
msoShapeCurvedUpArrow | 47 | 向上弯曲的方块箭头 |
msoShapeCurvedUpRibbon | 99 | 向上弯曲的功能区横幅 |
msoShapeDecagon | 144 | Decagon |
msoShapeDiagonalStripe | 141 | 删除了两个三角形形状的矩形;对角线 |
msoShapeDiamond | 4 | 菱形 |
msoShapeDodecagon | 146 | Dodecagon |
msoShapeDonut | 18 | 甜甜 圈 |
msoShapeDoubleBrace | 27 | 双大括号 |
msoShapeDoubleBracket | 26 | 双括号 |
msoShapeDoubleWave | 104 | 双波 |
msoShapeDownArrow | 36 | 向下指向的块箭头 |
msoShapeDownArrowCallout | 56 | 带有向下箭头的标注 |
msoShapeDownRibbon | 98 | 功能区下中心区域位于功能区末端的功能区横幅 |
msoShapeExplosion1 | 89 | Explosion |
msoShapeExplosion2 | 90 | Explosion |
msoShapeFlowchartAlternateProcess | 62 | 备用流程图符号 |
msoShapeFlowchartCard | 75 | 卡片流程图符号 |
msoShapeFlowchartCollate | 79 | 排序规则流程图符号 |
msoShapeFlowchartConnector | 73 | 连接器流程图符号 |
msoShapeFlowchartData | 64 | 数据流程图符号 |
msoShapeFlowchartDecision | 63 | 决策流程图符号 |
msoShapeFlowchartDelay | 84 | 延迟流程图符号 |
msoShapeFlowchartDirectAccessStorage | 87 | 直接访问存储流程图符号 |
msoShapeFlowchartDisplay | 88 | 显示流程图符号 |
msoShapeFlowchartDocument | 67 | 文档流程图符号 |
msoShapeFlowchartExtract | 81 | 提取流程图符号 |
msoShapeFlowchartInternalStorage | 66 | 内部存储流程图符号 |
msoShapeFlowchartMagneticDisk | 86 | 磁盘流程图符号 |
- Sub Lll()
- Dim Sht As Worksheet
- Set Sht = Sheet6
-
- Dim Rng As Range
-
- Dim ii, jj, Kk As Integer
- Dim Arr
- Arr = msoShapeAutoTypeArr
- Dim Shp As Shape, ShpRng As ShapeRange
- Dim GroupStart As Integer, GroupEnd
- ''
- Dim Ll, Tt, Ww, Hh, Lll
- Ww = 200
- Hh = 100
- For ii = Sht.Shapes.Count To 1 Step -1
- Set Shp = Sht.Shapes(ii)
- Shp.Delete
- Next ii
- ''
- Lll = 10
- Tt = 10
- GroupStart = 1
- For ii = GroupStart To 183 Step 4
- GroupEnd = GroupStart + 3
- With Sht
- Lll = Ll
- For jj = GroupStart To GroupEnd
-
- Set Shp = .Shapes.AddTextbox(msoTextOrientationHorizontal, Ll, Tt, Ww, Hh)
- Kk = Kk + 1
- If Kk > 183 Then
- Exit For
- End If
- Ll = Ll + Ww * 1.5
- Debug.Print ii, jj, Kk, Arr(Kk)(1), Arr(Kk)(2), Arr(Kk)(3)
- Select Case Arr(Kk)(2)
- Case -2, 138 ', 103
- 'Stop
- Case Else
- Shp.AutoShapeType = Arr(Kk)(0)
- With Shp
- .Fill.Visible = msoFalse
- With .Line
- .Visible = msoCTrue
- .Weight = 1
- .ForeColor.RGB = RGB(0, 0, 0)
- End With
- '.TextFrame2.TextRange.Text = Arr(ii)(3)
- With .TextEffect
- .FontSize = 8
- .FontBold = -msoCTrue
- .Alignment = msoTextEffectAlignmentCentered
- .Text = Arr(ii)(3) & vbCr & Arr(ii)(2) & vbCr & Arr(ii)(1)
- End With
- End With
- End Select
- Next jj
- Ll = Lll
- End With
- '''
- Tt = Tt + Hh * 1.5
- Next ii
- End Sub
复制代码
|
|
|