vba Excel 控件中的 EMBED 函数是什么意思?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/9373348/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-08 12:36:18  来源:igfitidea点击:

What does EMBED function mean in Excel Controls?

excelexcel-vbaexcel-formulavba

提问by Nap

I am adding a button in an existing Excel file. I noticed that the existing buttons has the EMBED formula specified to it. What does the function mean?

我正在现有的 Excel 文件中添加一个按钮。我注意到现有按钮指定了 EMBED 公式。函数是什么意思?

=EMBED("Forms.CommandButton.1","")

采纳答案by Siddharth Rout

Honestly there really is not much documentation available on this "function". It is one of those things which are exposed unnecessarily when it really shouldn't have been. We are not supposed to enter this manually.

老实说,关于这个“功能”的文档确实不多。它是那些在不应该暴露的情况下不必要地暴露的事情之一。我们不应该手动输入。

When you select a CommandButton and place it in Excel, you will see

当您选择一个命令按钮并将其放置在 Excel 中时,您将看到

=EMBED("Forms.CommandButton.1","") 

in the Formula Bar. This text is necessary and should not be deleted. It is Excel's way of telling itself that an object has been inserted.

在公式栏中。这段文字是必要的,不应删除。这是 Excel 告诉自己对象已插入的方式。