![]() I've tried loading and showing the form before assigning it to oForm. This is meant to be a generic procedure that can add a bunch of controls to whatever form. I can say oForm.BackColor = vbred, and I can set ctl = oform.TextBox1 for example When I open the Developer tab, click on Visual Basic, and then go to the Insert menu, my only option is to add a module or class module. In the Locals window, oForm does not have a height property, so fair enough. User Form in VBA for Excel in Office 365 for MAC I am attempting to build a User Form in VBA for Excel with MS Office 365 for MAC. OForm.Height = i //object does not support this property or method stuff happens here, oForm is used extensively In FormMan class module: Public Sub Addcontrols(iNum as integer, oForm as userform) oF.AddControlsToForm iNumberOfControls,frmTest ![]() The user passes the number of controls and the userform. One particular method is to be called from a lot of different places and is pretty simple - it simply adds a user defined number of controls to a form and extends the forms height to accommodate these new controls. If the Project Explorer is not visible, click View, Project Explorer. To create this Userform, execute the following steps. Specify path to user folder in VBA for both Windows and Mac. I have a class module, let's call it FormMan which has a bunch of methods relating to the large number of userforms I have in my project. VBA (Excel) Dictionary on Mac Using VBA: Assign value to label control on userform. ![]() I'm really struggling with something here.
0 Comments
Leave a Reply. |