Creating a WHILE Loop in Visio ShapeSheet

Question

I'm aware that this can be easily done using VBA, but I'd like a macroless solution if possible.

I have 2 User rows in a Shape's ShapeSheet: User.Count and User.Loop. User.Count will simply store a number, and the While loop will be performed by User.Loop using the following basic conditional:

User.Loop = IF(User.Count < 1000, SETF(GETREF(User.Count), User.Count + 1), "Loop complete!")  + DEPENDSON(User.Count)

This executes to User.Count = 41 (these pulses of 41 are consistent). Is performing this type of loop possible?

Answer 1

because if the answer ever becomes 42 then that is the end of Life, The Universe and Everything!

Paul you are right ! :)

changing the loop limit to 40 and

Sad, but this trick dont works…

---

My experiment results.

My example file
My loop can't make it to the 1000 mark. It has to stop at 80. You can continue the loop through the context menu Go to 1000 limit.