Forum Discussion
Mac OS UserForm Alternative
I'm looking for an alternative add-ins to create user forms in VBA for Mac, since the Microsoft team removed it from the recent versions for Mac OS. Do you guys have any suggestions?
You can generate user forms via code. Instructions and example code are given in the link below. In the Visual Basic Editor (VBE) be sure to use the Tools menu > References and set these References before running the example code:
- Microsoft Visual Basic for Applications Extensibility 5.3
Microsoft Forms 2.0 Object Library
Here's more example code
To get this to work you also have to go to "Excel>Preferences>Secutity>", under "Developer Macro Setting", tick "Trust access to the VBA project object model".