Creating a Create UserForm Add In for Excel for Mac OS

[Geremias Fontes]

Hi Everybody, I'm new here. I work with Mac and I started study Excel for Mac (version 2019 for Mac) earlier this year and I faced many limitation but I like challenges. I soon as I discovered the UserForm limitation I started doing a research about it and discovered that UserForm exist in Excel for Mac but it is not correctly implemented. In my research i found a way to create a UserForm directly from Mac without the need of going to windows to do it.
I'm developing everything with VBA and I'd like to created an Add-in in which you inside you own Excel document will be capable to create a UserForm.
My question is: First: I don't know how to create an Add-In using my VBA code. Can I have some direction on where to start?
Second: Is it possible to earn money in case my Add-in really solves this limitation of Excel for Mac?

 

[Geremias Fontes]

It's not finished yet, but here is 2 screenshots .

 

[Geremias Fontes]

Now it worked... the images were too large. Sorry.

 

[xrobtx]

Any luck with this project? I am running into the same issue with user forms and would love a viable solution.

 

[iantech]

Any luck with this project? I am running into the same issue with user forms and would love a viable solution.

I’ve just about completed what I think can be a useful add-in that works on Mac and windows OS, it’s written entirely in VBA.
You'd probably be able to use something like this if your forms are needed for data entry, searches etc.
I’d like to share it, but I’m actually looking for a few people to give it a test-drive before making it publicly available for free download. If interested, please DM I can send you a link and a password to download.

In the early 2000s I think; Excel author and MVP John Walkenbach did a similar form to enhance the built-in Excel Data form. This one seeks to provide that functionality and quite a bit more.

You can automatically launch Forms from any data table in 1 click without any preliminary setup.

Form appearance and behavior can easily be customised via point and click interface.

The forms are Dynamic, Resizable and generated with a single click - No coding required.

They allow you to Add, Edit , Delete Data. They are synchronized with Excel Filters , Enforce Data validation rules on forms , include Intelligent Data-driven control types.

There’s a Browse/Find window with dynamic search Form to quickly navigate and find Table Data

Also a quick report generator – Click and Choose columns and Generate a report

There's an advanced option to generate actual forms in the Visual Basic Editor that are customizable.
A quick look can be seen here:

Would welcome any feedback.