“= EMBED（”Forms.CheckBox.1“，”“”）“做复选框？ [英] What does "=EMBED("Forms.CheckBox.1","")" do for checkboxes?
问题描述
这有什么意义？我的复选框有什么作用？我在VBA代码中找不到任何地方。
1993年，Microsoft将VBA（Visual Basic for Applications）添加到Excel中，并发布了Excel 5。
$在此之前，Excel包含一个完全不同的宏语言，称为XLM（Excel宏）。XLM宏具有公式语法，甚至在Excel中有一个特殊的表格类型，用于称为宏表的XLM宏。
即使在Excel 2013中，XLM宏仍然可以运行。
这个宏表格是现在更广泛使用的正常工作表和图表表。EMBED（）是Excel使用的XLM函数，将另一个OLE应用程序嵌入到工作表中。它不是VBA的一部分。
作为MSForms 2.0对象库的一部分，VBA中包含复选框的ActiveX控件。
当您将任何OLE对象插入到工作表中时，Excel会使用XLM EMBED（）函数链接到该对象。作为用户，您不需要直接编辑此公式。
在您的情况下，它链接到MSForms 2.0对象库中的复选框控件。
这允许复选框控件在工作表中实际运行，而不是用户窗体。
I have an excel sheet with a large amount of checkboxes. I copy and pasted the checkboxes around, and every single one of them has =EMBED("Forms.CheckBox.1","") in the formula bar.
What is the significance of this? What does it do for my checkboxes? I can't find it anywhere in the VBA code.
In 1993 Microsoft added VBA (Visual Basic for Applications) to Excel with the release of Excel 5.
Prior to that Excel included a completely different macro language, known as XLM (Excel Macros).
XLM macros have a formula syntax, and there is even a special sheet type in Excel for XLM macros called a Macro Sheet. These macro sheets are in addition to the normal worksheets and chart sheets that are more widely used today.
XLM macros still function now, even in Excel 2013.
EMBED() is an XLM function that is used by Excel to embed another OLE application into a worksheet. IT IS NOT PART OF VBA.
The ActiveX controls, of which the checkbox is one, are included with VBA as part of the MSForms 2.0 Object Library.
When you insert any OLE object into a worksheet, Excel uses the XLM EMBED() function to link to that object. As a user, you are not meant to edit this formula directly.
In your case it is linking to the checkbox control in the MSForms 2.0 Object Library.
This allows the checkbox control to actually function in the worksheet instead of on a userform.
这篇关于“= EMBED（”Forms.CheckBox.1“，”“”）“做复选框？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
