Creating a Create UserForm Add In for Excel for Mac OS

Geremias Fontes

New Member
Joined
Aug 24, 2023
Messages
3
Office Version
  1. 2019
Platform
  1. MacOS
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?
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Now it worked... the images were too large. Sorry.
 

Attachments

  • Foto1.jpg
    Foto1.jpg
    48 KB · Views: 376
  • Foto2.jpg
    Foto2.jpg
    61.1 KB · Views: 375
Upvote 0
Any luck with this project? I am running into the same issue with user forms and would love a viable solution.
 
Upvote 0

Forum statistics

Threads
1,224,818
Messages
6,181,152
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top