visioshapesheet

Creating a WHILE Loop in Visio ShapeSheet

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?

Solution

  • 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.
    enter image description here
    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.