bull699
11-10-2015, 02:45 AM
Hi
I'm using this to create a button with an assigned macro
Sub CreateButton()
ActiveSheet.Buttons.Add(199.5, 20, 81, 36).Select
Selection.Name = "New Button"
Selection.OnAction = "MoveValue"
ActiveSheet.Shapes("New Button").Select
Selection.Characters.Text = "Check Totals"
End Sub
However, I want to create the button multiple times, each time offsetting from the previous button running down the Y axis. Essentially I want something like End(xlUp).Offset(1), something that recognises that the space is already taken by another button.
Many Thanks
I'm using this to create a button with an assigned macro
Sub CreateButton()
ActiveSheet.Buttons.Add(199.5, 20, 81, 36).Select
Selection.Name = "New Button"
Selection.OnAction = "MoveValue"
ActiveSheet.Shapes("New Button").Select
Selection.Characters.Text = "Check Totals"
End Sub
However, I want to create the button multiple times, each time offsetting from the previous button running down the Y axis. Essentially I want something like End(xlUp).Offset(1), something that recognises that the space is already taken by another button.
Many Thanks