n trying to typecast a Text Excel reference into ActiveX. When I browse ActiveX Class I can select Microsoft Excel Textbox, but not if I check the Createable objects only box. Is this the source of my error? Is there a way to make this a creatable object?Only selected on objects can be created. They are typically stand-alone objects that do not depend upon a relationship to another object. The Textbox can only exist on a worksheet and an EditBox can only exist on a form.
If you want to create a TextBox on your worksheet, use the ActiveX function:
Excel._Worksheet.Shapes.AddTextbox (orientation, left, top, width, height)You can add several TextBoxes and position each one where you want it on the sheet. I recommend that you cascade the AddTextbox reference into a Property Node->Name and use the Item method to select each TextBox by Name. See the screenshot example.
Michael Munroe
Certified LabVIEW Developer
www.abcdef.biz
