Place Button (Forms Toolbar) Based on Cell Address

  • Hi,
    I am seeking to place a Button from the Forms Toolbar in a Spreadsheet via VBA. Currently i have this bit

    Code
    ActiveSheet.Buttons.Add(220, 210, 155, 26).Select

    How can I fix it so that the button is added at a specific cell? I.e. Top left of the button should be top left of cell A17, or can i find the center of say A17 and it for the first two reference points?
    Thank you,
    Stefan

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!