LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jzz Jzz is offline
external usenet poster
 
Posts: 20
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
moving objects with cell martinson Excel Worksheet Functions 0 July 3rd 08 03:13 PM
Moving Objects in a Worksheet Native Excel Discussion (Misc queries) 2 January 11th 06 02:56 AM
Objects moving when printing Squid[_5_] Excel Programming 8 April 22nd 05 08:12 PM
Moving objects on a form Steven K Excel Programming 1 August 23rd 04 06:13 PM
Moving Chart Objects Matt Excel Programming 6 May 1st 04 03:34 PM


All times are GMT +1. The time now is 10:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"