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. For example, if you pressed the shortcut key now while reading this page on your computer browser, it would close the browser window and all open tabs. This seems to demonstrate that it is possible to insert a UserForm control into a VBProject. Alt F4 Excel Mac Alt+F4 is a shortcut key most often used to close the current active window. '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. 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)
A screenshot of a programmatically generated UserForm object in Excel for Mac - Microsoft 365
