在Visio ShapeSheet中创建一个WHILE循环。

huangapple go评论55阅读模式
英文:

Creating a WHILE Loop in Visio ShapeSheet

问题

我知道可以使用VBA轻松完成这个任务,但如果可能的话,我想要一个不需要宏的解决方案。

在一个形状的ShapeSheet中,我有两个用户行:User.CountUser.LoopUser.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 &lt; 1000, SETF(GETREF(User.Count), User.Count + 1), &quot;Loop complete!&quot;)  + 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 ! 在Visio ShapeSheet中创建一个WHILE循环。

保罗,你说得对! 在Visio ShapeSheet中创建一个WHILE循环。

changing the loop limit to 40 and

将循环限制更改为40和

Sad, but this trick dont works…

可悲的是,这个技巧不起作用...


My experiment results.

我的实验结果。

在Visio ShapeSheet中创建一个WHILE循环。

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.

我的循环无法达到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 ! 在Visio ShapeSheet中创建一个WHILE循环。

> changing the loop limit to 40 and

Sad, but this trick dont works…


My experiment results.
在Visio ShapeSheet中创建一个WHILE循环。
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.

huangapple
  • 本文由 发表于 2023年6月1日 22:32:21
  • 转载请务必保留本文链接:https://go.coder-hub.com/76383000.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定