英文:
Creating a WHILE Loop in Visio ShapeSheet
问题
我知道可以使用VBA轻松完成这个任务,但如果可能的话,我想要一个不需要宏的解决方案。
在一个形状的ShapeSheet中,我有两个用户行:User.Count
和 User.Loop
。User.Count
将简单地存储一个数字,而 While 循环将由 User.Loop
执行,使用以下基本条件:
User.Loop = IF(User.Count < 1000, SETF(GETREF(User.Count), User.Count + 1), "Loop complete!") + DEPENDSON(User.Count)
这将执行为 User.Count = 41
(这些41的脉冲是一致的)。执行这种类型的循环是否可能?
英文:
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?
答案1
得分: 1
because if the answer ever becomes 42 then that is the end of Life, The Universe and Everything!
因为如果答案变成42,那就是生命、宇宙和一切的终结!
Paul you are right !
保罗,你说得对!
changing the loop limit to 40 and
将循环限制更改为40和
Sad, but this trick dont works…
可悲的是,这个技巧不起作用...
My experiment results.
我的实验结果。
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
.
我的循环无法达到1000标记。它必须在80处停止。您可以通过上下文菜单“转到1000限制”继续循环。
英文:
> 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
.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论