Forum Discussion
Anthgrim
Apr 20, 2021Copper Contributor
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
Sort By
- ianh8000Copper 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/q6AMgkPfvfif 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- bhumphries1313Copper ContributorJust sent you a message, sir.
- JKPieterseSilver ContributorAll I can think of is installing Windows on a virtual machine on your Mac 🙂
- 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