I've recorded a macro where i create a button
Sub Macro1()
ActiveSheet.Buttons.Add(366.75, 27, 128.25, 75).Select
End Sub
pretty straight forward.
I dont like to use ".select" too much, since that is recording-language. That means excel select it, and i dont need that.
To me, it would make sense if i could use
Sub Macro1()
ActiveSheet.Buttons.Add(366.75, 27, 128.25, 75)
End Sub
why doesnt this add a button?
I've tried to declare the variable, but i dont know what the variable for button is. Theres no such thing as controlbutton, commandbutton, or simply, button.
Anyone familiar with any of this?
Bookmarks