Cell A1 is 28 wide x 19.5 high.
My code works perfectly where the button is the same height as the cell, but the width isn't matching up. I'm trying to make the button half the size of the cell.
I don't understand why the height works perfectly, but following the same idea the width isn't even close to being half the cell. How is the width calculated?
Thank you
My code works perfectly where the button is the same height as the cell, but the width isn't matching up. I'm trying to make the button half the size of the cell.
VBA Code:
ActiveSheet.Buttons.Add(Range("B1").Left, Range("B1").Top, -14, 19.5).Select
Thank you