Mac OS UserForm Alternative

%3CLINGO-SUB%20id%3D%22lingo-sub-2279567%22%20slang%3D%22en-US%22%3EMac%20OS%20UserForm%20Alternative%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2279567%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20looking%20for%20an%20alternative%20add-ins%20to%20create%20user%20forms%20in%20VBA%20for%20Mac%2C%20since%20the%20Microsoft%20team%20removed%20it%20from%20the%20recent%20versions%20for%20Mac%20OS.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20guys%20have%20any%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2279567%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2279834%22%20slang%3D%22en-US%22%3ERe%3A%20Mac%20OS%20UserForm%20Alternative%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2279834%22%20slang%3D%22en-US%22%3EAll%20I%20can%20think%20of%20is%20installing%20Windows%20on%20a%20virtual%20machine%20on%20your%20Mac%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2724820%22%20slang%3D%22en-US%22%3ERe%3A%20Mac%20OS%20UserForm%20Alternative%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2724820%22%20slang%3D%22en-US%22%3EBe%20sure%20you%20have%20updated%20to%20Excel%20version%2016.52%20or%20newer%3CBR%20%2F%3EIt%20appears%20that%20you%20can%20now%20generate%20user%20forms%20via%20code.%20Instructions%20and%20example%20code%20are%20given%20in%20the%20link%20below.%20Be%20sure%20to%20use%20the%20Tools%20menu%20%26gt%3B%20References%20and%20set%20these%20Ref-erences%20before%20running%20the%20example%20code%3A%3CBR%20%2F%3EMicrosoft%20Visual%20Basic%20for%20Applications%20Extensibility%205.3%3CBR%20%2F%3EMicrosoft%20Forms%202.0%20Object%20Library%3CBR%20%2F%3EVBA%20Express%20%3A%20Excel%20-%20Programmatically%20Add%20a%20UserForm%3CBR%20%2F%3EThis%20should%20get%20you%20started.%20I%20think%20you%20can%20now%20use%20code%20to%20add%2C%20remove%20and%20modify%20the%20userform%20and%20its%20controls.%20Please%20give%20this%20a%20try%20and%20reply%20whether%20or%20not%20this%20works%20for%20you.%3CBR%20%2F%3EThanks%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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?

 

3 Replies
All 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