Excelvbaでクリックしたボタンの座標取得

MsgBox ActiveSheet.Shapes(Application.Caller).Left
MsgBox ActiveSheet.Shapes(Application.Caller).Top
MsgBox ActiveSheet.Shapes(Application.Caller).Width
MsgBox ActiveSheet.Shapes(Application.Caller).Height

$A$2 とかの書式ならこちら

MsgBox ActiveSheet.Shapes(Application.Caller).TopLeftCell.Address

ネタ元

• https://kosapi.com/post-3126/
• https://www.moug.net/tech/exvba/0150104.html