It also suggests that the underpinnings of UserForm support do indeed exist in Excel for Mac but they are as of yet not fully implemented. This seems to demonstrate that it is possible to insert a UserForm control into a VBProject. 'Execute the following statement once for each userform object to be created The form is invoked via a macro attached to a custom button on the Ribbon. I also added code to the automatically generated CommandButton1_Click() event procedure stub.
So I added code to the UserForm_Initialize() event procedure, manually positioning and configuring the existing controls. I briefly saw the visual editor and was able to drag and drop a label control and a command button,for the newly created form but subsequent attempts failed. This created a userform object named UserForm1. Enter 1.333333, the ratio between pixels and points, and this is how it will be resized for the Mac, though it’s too large for Windows. The userform object had to be generated by invoking the Add() method on the VBComponents collection of the VBProject associated with the ThisWorkbook object, as follows: Set objForm = (vbext_ct_MSForm) Enter a number in the New Form Magnification box (for example 2) and click Apply, and the form is resized accordingly. A screenshot of a programmatically generated UserForm object in Excel for Mac - Microsoft 365
