excel在线脚本的消息框
我正在努力将所有 VBA 脚本转换为 Excel Online 自动化。有谁知道如何将 MsgBox 从 VBA 转换为 Excel Online 自动化吗？
例如：MsgBox“一些文本”
我将我的代码设置为附加到按钮以供用户选择。我试图使我的代码尽可能对用户友好，但目前人们看到生成的消息的唯一方法是选择“查看日志”来查看来自 console.log(“Some Text”) 的消息。
只是想确保消息被阅读，这样我就不会被问题轰炸，比如为什么它没有运行或者为什么它没有做它应该做的事情。当它确实运行正确但他们需要解决消息并重新运行时。消息可能很简单，例如“输入框中缺少日期”或“数据尚未更新。请更新并再次运行”。
先感谢您！
I am working on converting all of my VBA scripts over to Excel Online automation. Has anyone figured out how to convert MsgBox from VBA to Excel Online automation?
ex: MsgBox "Some Text"
I'm setting my code attached to buttons for users to select. I'm trying to make my code as user friendly as possible but currently the only way someone will see a generated message is if someone selects "View Logs" to see messages from a console.log("Some Text").
Just trying to make sure that messages are read so I don't get bombarded with questions as to why it didn't run or why it didn't do what it was supposed to do. When it did run correctly but they need to resolve the message and re-run. Messages might be something as simple as "Date missing from input box" or "Data has not been updated. Please update and run again".
Thank you in advance!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
这需要一堆挖掘，但我最终找到了它。要获取一条消息以显示某人使用Excel在线使用“投掷”然后您的文本运行自动化脚本时显示的消息。这甚至将根据我阅读的内容发送与MS流量一样高的消息。
我不知道我在这个网站上找到它的位置（ https://learn.microsoft.com/en-us/office/dev/scripts/?view=office-scripts ），但是有一个PDF可以更好地解释所有不同的Excel在线自动化功能。如果您发现它的生活会更加轻松。
This took a bunch of digging but I eventually found it. To get a message to display when someone runs an automation script using Excel Online use "throw" then your text. This will even send the message as high as MS Flow based on what I have read.
I don't know where I found it on this site (https://learn.microsoft.com/en-us/office/dev/scripts/?view=office-scripts), but there is a PDF that does a much better explanation of all the different Excel Online automation functions. If you find it your life will be so much easer.