Forum Discussion

Anthgrim's avatar
Anthgrim
Copper Contributor
Apr 20, 2021

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?  
Macros and VBA
JKPieterse's avatar
JKPieterse
Silver Contributor
Apr 21, 2021
All I can think of is installing Windows on a virtual machine on your Mac 🙂
JimGMac's avatar
JimGMac
MVP
Sep 06, 2021
Be sure you have updated to Excel version 16.52 or newer
It appears that you can now generate user forms via code. Instructions and example code are given in the link below. Be sure to use the Tools menu > References and set these Ref-erences before running the example code:
Microsoft Visual Basic for Applications Extensibility 5.3
Microsoft Forms 2.0 Object Library
VBA Express : Excel - Programmatically Add a UserForm
This should get you started. I think you can now use code to add, remove and modify the userform and its controls. Please give this a try and reply whether or not this works for you.
Thanks
    • pcsrvc's avatar
      pcsrvc
      Copper Contributor
      Jul 08, 2022

      JimGMac I tested the code in the link you posted but it did not work. I get an error that variable showform is not declared.

       

      Still looking for a solution.

       

      • JimGMac's avatar
        JimGMac
        MVP
        Jul 09, 2022

        pcsrvc 

        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

        VBA Express : Excel - Programmatically Add a UserForm

Resources