Repeated Cell Changed Events

[ken.street]

I have an application that uses VBA to control a Visio 2003 document.
When the user moves one of the shapes, it is detected through an event,
which may or may not in turn move the shape again. What I am
encountering is that the visEvtMod + visEvtCell event applied through
AddAdvise is being evaluated over and over (circa 20 times before
stopping) and I have not found any way of cancelling these repeated
automatic "events".

Any assistance would be greatly appreciated!

 

[Paul Herber]

I have an application that uses VBA to control a Visio 2003 document.
When the user moves one of the shapes, it is detected through an event,
which may or may not in turn move the shape again. What I am
encountering is that the visEvtMod + visEvtCell event applied through
AddAdvise is being evaluated over and over (circa 20 times before
stopping) and I have not found any way of cancelling these repeated
automatic "events".

The visEvtCell is firing for every cell that gets modified, try the
visEvtShape event instead, that should only fire once.

 

[ken.street]

Paul

Thanks for the suggestion but visEvtShape is not being triggered if the
shape is moved as the documentation describes only limited changes
which trigger a ShapeChanged event and PinX and PinY are not one of
them. Moving and changing the Shapes' shape do not trigger the event so
I cannot detect the user action.

Ken

 

[Paul Herber]

Sorry, got that wrong. Try visEvtFormula, you will need to filter the
cell name causing the event.