ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Moving objects (https://www.excelbanter.com/excel-programming/343018-moving-objects.html)

Jzz

Moving objects
 
Hi,
I have a macro that draws shapes in certain places. After the shapes
are in place, the user has to be able to move the shapes. When the user
is done with that, the macro has to see where the shape is and
calculate some things.
The I can start a routine when the user clicks on one of the shapes,
and see which shape it is (application.caller). But then I have to let
the user move the object and when he (or she) is finished and deselects
the shape in question, the routine must calculate the place. This is
where it went wrong. The best I came up with is something like:

do until sh.left < 50
DoEvents
loop

This works, but instead the "sh.left < 50" there should be something
like "sh < selection", but this does not exists.
Maybe there is an other command, or another way how to solve this
problem.

I hope somebody can help me, I've been puzzling quite a lot on this
one.

Jzz



All times are GMT +1. The time now is 07:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com