Option Explicit
Sub tes()
Dim s As Object
Set s = ActiveSheet.Buttons.Add(127, 42, 90, 20)
With s
.OnAction = "Test"
.Name = "test"
End With
End Sub
Option Explicit
Sub tes()
Dim s As Object
Set s = ActiveSheet.Buttons.Add(127, 42, 90, 20)
With s
.OnAction = "Test"
.Name = "test"
.Caption = "test"
End With
End Sub