VBA for executing macro when a shape is moved/altered?

[frabulator]

I am looking for a way to execute a macro when an object with a specific name is updated, moved or changed. Is this possible, and if it is, could someone please point me in the correct direction or give me a sample code?

Many thanks!

Frab~

 

[frabulator]

Re: VBA for exicuting macro when a shape is moved/altered?

bump

 

[My Aswer Is This]

Re: VBA for exicuting macro when a shape is moved/altered?

Be more specific. What type object?
Generally speaking I do not believe a script will run when a object is moved.
Now changing a object may cause a script to run but we would need to know what type change.

Give us a example of something you want to do.

 

[frabulator]

Re: VBA for exicuting macro when a shape is moved/altered?

Be more specific. What type object?

Give us a example of something you want to do.

Sorry, I should have been more specific.

I have a shape (a rectangle to be precise) with a unique name ("DrawingWindowEample"). Inside this rectangle shape I have other shapes (lines, circles, arcs, etc) that are populated within that rectangle's borders. All of these objects are populated via a Macro.

What I would like is a way to execute that macro when the rectangle is changed in any way; size changes, location changes, width, etc. By doing so I want to update/re-populate the shapes inside the rectangle automatically. Is this possible?

 

[My Aswer Is This]

Re: VBA for exicuting macro when a shape is moved/altered?

Sorry, I should have been more specific.

I have a shape (a rectangle to be precise) with a unique name ("DrawingWindowEample"). Inside this rectangle shape I have other shapes (lines, circles, arcs, etc) that are populated within that rectangle's borders. All of these objects are populated via a Macro.

What I would like is a way to execute that macro when the rectangle is changed in any way; size changes, location changes, width, etc. By doing so I want to update/re-populate the shapes inside the rectangle automatically. Is this possible?

I know of no way to do that. But there are a lot of other people who may have a answer for you. We will see who else here may have another answer for you.

 

[frabulator]

Re: VBA for exicuting macro when a shape is moved/altered?

I know of no way to do that. But there are a lot of other people who may have a answer for you. We will see who else here may have another answer for you.

Well thank you for your help anyway

 

[frabulator]

Re: VBA for exicuting macro when a shape is moved/altered?

bump

 

[frabulator]

Re: VBA for exicuting macro when a shape is moved/altered?

bump :?

 

[Jaafar Tribak]

Re: VBA for exicuting macro when a shape is moved/altered?

If you group the shapes together then any change in size or location of the rectangle container shape should also affect the shapes that are inside it.

To group the shapes just select them all with the mouse, rightclick the mouse and choose Grroup from the right-click menu.

 

[frabulator]

Re: VBA for exicuting macro when a shape is moved/altered?

If you group the shapes together then any change in size or location of the rectangle container shape should also affect the shapes that are inside it.

While that is neat, and I think it would work in many situations, it will not work for what I want to do. If the rectangle is resized I will need to redraw the shapes inside of it as they should not be scaled with the rectangle. The shapes inside need to stay the same aspect ration when the rectangle is resized.