Advertisement
Guest User

Untitled

a guest
May 3rd, 2015
156
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. Sub MakeButton()
  2. ActiveSheet.Shapes.AddShape(msoShapeOval, 228#, 557.25, 126.1, 126.1).Select
  3. With Selection
  4. .Characters.Text = "1 ADDER"
  5. .ShapeRange.Fill.Visible = msoTrue
  6. .ShapeRange.Fill.ForeColor.SchemeColor = 3
  7. .ShapeRange.Line.Visible = msoTrue
  8. .ShapeRange.Line.ForeColor.SchemeColor = 3
  9. .ShapeRange.Line.BackColor.RGB = RGB(255, 255, 255)
  10. .Name = "MyButton"
  11. .OnAction = "whatever"
  12. .Top = Range("C3").Top
  13. .Left = Range("C3").Left
  14. End With
  15. End Sub
  16.  
  17. Sub whatever()
  18. Cells(ActiveCell.Row, 1).Value = 1
  19. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement