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?

 

11 Replies

  • ianh8000's avatar
    ianh8000
    Copper Contributor

    Anthgrim
    I'm finalizing an add-in that can work on Mac OS  that will build userforms automatically  fromm worksheet data .it will allow data entry, navigation, searching etc.
    Hopefully soon, there will be a free version.  It's described here:
    https://www.reddit.com/r/Excel4Mac/s/q6AMgkPfvf

     

    if you want to try it out you can msg me and i will send a link to the docs, the xlam  and help file.

    Ian

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    All I can think of is installing Windows on a virtual machine on your Mac 🙂
    • JimGMac's avatar
      JimGMac
      MVP
      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

Resources