維基百科SVG EXCEL VBA繪圖 EXCEL VBA繪圖程式碼 Sub 劉任昌() For i = 0 To 4 ActiveSheet.Shapes.AddShape(msoShapeOval, i * 200, 0, 200, 200).Fill.ForeColor.RGB = RGB(255, 255, 0) ActiveSheet.Shapes.AddShape(msoShapeOval, i * 200 + 50, 50, 30, 20).Fill.ForeColor.RGB = RGB(0, 0, 0) ActiveSheet.Shapes.AddShape(msoShapeOval, i * 200 + 120, 50, 30, 20).Fill.ForeColor.RGB = RGB(0, 0, 0) ActiveSheet.Shapes.AddShape(msoShapeRectangle, i * 200 + 90, 80, 20, 50).Fill.ForeColor.RGB = RGB(0, 0, 255) ActiveSheet.Shapes.AddShape(msoShapeRectangle, i * 200 + 70, 150, 60, 15).Fill.ForeColor.RGB = RGB(255, 0, 0) Next End Sub
留言
張貼留言