Advertisement
Guest User

Untitled

a guest
Jul 21st, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. Sub Create_arcs()
  2.  
  3. Dim MyShape As Shape
  4.  
  5. 'Your number of parts in the circle
  6. NumParts = 6
  7.  
  8. For i = 1 To NumParts
  9.  
  10. Set MyShape = ActiveSheet.Shapes.AddShape(msoShapeBlockArc, 0.75, 0.75, 146.25, 146.25)
  11. With MyShape
  12.  
  13. .Adjustments.Item(1) = i * 360 / NumParts
  14. .Adjustments.Item(2) = i * 360 / NumParts + 360 / NumParts
  15. 'Size of internal doughnut
  16. '.Adjustments.Item(3) = .2
  17.  
  18. 'Format for each sharpe
  19. .Fill.ForeColor.RGB = RGB(i * 20, i * 20, i * 20)
  20. .Line.ForeColor.RGB = RGB(255, 255, 255)
  21. .Line.Weight = 3
  22.  
  23. End With
  24.  
  25. Next i
  26.  
  27. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement