Event triggered when a shape is moved

[justin-uk]

I have searched the forums for an answer to this and haven't found anything, but I am forever hopeful!

Is there a way to trigger a macro when a shape is moved by the user? If I set the OnAction property for a shape, then the cursor changes to a hand when it is over the shape, and I can detect a mouse click on the shape, but I cannot drag and drop the shape. If I reset the OnAction property to "" (empty quotes), then I can drag and drop again within the worksheet, but I can't trigger the macro.

Worksheet_Change or Worksheet_SelectionChange are not triggered by this event.

People have suggested using timers to continuously poll the shapes and determine their locations, but is there an easier way?

What I am trying to do is create a sheet where the user can visually move around objects (in this case representing employees) and deposit them in various zones. The spreadsheet would then apply certain attributes to the shape i.e. change colour according to where the shape is and if it is in an unsuitable zone. I can do all of this, but I want it to work the instant the shape is moved, not rely on the user to hit a button.

Thanks,

Justin

 

[mahmed1]

Thank you

 

[mahmed1]

Even if it means that you can help me do the following

When a couple of specific shapes is dragged into the drag area (shape) I want to fire off a macro and also change the mouse cursor to the hand signal when i am over the shapes that can be dragged

Thank you

if possible - once the shape is dragged into the drag area, i want to hide this dragto area and display my gif file named - loading.gif

 

[Jaafar Tribak]

Even if it means that you can help me do the following

When a couple of specific shapes is dragged into the drag area (shape) I want to fire off a macro and also change the mouse cursor to the hand signal when i am over the shapes that can be dragged

Thank you

if possible - once the shape is dragged into the drag area, i want to hide this dragto area and display my gif file named - loading.gif

Take a look here and see if you can adpat the code to meet your specific needs : https://www.mrexcel.com/forum/excel...-when-shape-moved-shapemove-pseudo-event.html

 

[mahmed1]

Hi Jaafar - thank you

i think im doing something wrong somewhere.

For me, i only need it to trigger the shape move and drop on certain shapes

At the min, it appears to be pulling info when any shaped is dragged

 

[Jaafar Tribak]

Hi Jaafar - thank you

i think im doing something wrong somewhere.

For me, i only need it to trigger the shape move and drop on certain shapes

At the min, it appears to be pulling info when any shaped is dragged

Hi mahmed1,

Just to let you know that I sent a private message to you but it seems that your inbox cannot accept further messages because it is full.