retrieve data informations in the Shape Data section on the ShapeSheet

Started by Miguel, March 28, 2017, 06:54:40 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Yacine

Yacine

wapperdude

Ok, got it.  So, is it still firing 3x?

If so, one method would be to modify the code.  Basically, it would check for a additional 2nd cell, which would indicate the shape has already been checked, do not check again.  For example, the modification  might add a User.ckd entry to User Defined section of the shape sheet.  A test for this entry should happen before the current cell exists test.  If new test fails, proceed with 2nd test.  If new test passes, then ignore this shape.  Add more code after 2nd test. If 2nd test is successful, then code should add the User.ckd entry to shapesheet.  If 2nd test for cell existence failed, no need to add the User.ckd entry as this shape already fails.  Hope that makes sense.  Basically, you're adding a "flag" to the shape which let's the macro know the shape was previously tested and was successful, thus, no need to check again.

Wapperdude
Visio 2019 Pro