Forum Discussion
Dynamically capturing the X, Y coordinates of objects
I have an excel file where users click and drag circles around the screen. I'd like to write a macro that captures the X, Y coordinates of the circles into selected cells. Ideally, it would update ...
Have a look here:
https://msdn.microsoft.com/en-us/vba/excel-vba/articles/shape-object-excel
The following two properties give you distance from left and Top
.Left
.Top
Not sure how you would detect object moving .... but haven't spent too much time looking