Excel VBA change button size and location

Question

How do I change a button size and location on an excel sheet?

Answer 1

You are almost there with ActiveSheet.Shapes("Button 1")

If you dim a variable as Shape and assign the button to it, you can use intellisence to explore the available properties. From there you will find .Height, .Width, .Left, .Top

Dim btn As Shape
Set btn = ActiveSheet.Shapes("Button 1")
btn.Height = 50
btn.Width = 100