Offset my buttons from activecell

[jlart]

All help welcome!

I would like to have my command buttons follow with an offset from my selection using VBA.
For instance, I select cell C7, I want my three command buttons to move to beginning F7.
To offset from cell C7.
thanks.

[MarvinP]

Hi jlart and welcome to the forum,
I wrote some code to do this a while back. Here it is:

Please Login or Register  to view this content.

First this must go behind the sheet, not in a module as it is event code. I hope you get that.
Then in the Immediate Window do debug.print activesheeet.shapes(1).name so VBA will tell you which command button (really a shape) you are about to move around.
Then put the correct index number to move one of your three buttons and base them on your ActiveCell.

I had my single command button move to the right and below my clicked on cell. This way the command button was always in veiw of what I was seeing on the screen,

Another way to accomplish a visible button is to put the Macro on the QAT (quick access toolbar). Hope all this helps.