Enable VBA Support for creating and editing UserForms (not the Data Form)
In previous versions of Mac Excel you could create a Form/Dialog using VBA (called a VBA UserForm). In Mac Excel 2016, you can no longer do this. Please bring that functionality back. Note that this is different than the "Form" option on the Data menu. There's a separate suggestion on UserVoice for that.
(March-2018: MS updated the Title and Description to avoid confusion with the Data Form request)
Thanks for all your votes and comments about enabling support for UserForms in Excel for Mac.
With emphasis on enabling more and more capability using Office add-ins in Excel that will work across platforms, we don’t expect to add support for creating and modifying UserForms.
Please see this article for more information about what you can do in Excel with Office add-ins.
Norbert K. commented
poor reaction from microsoft not being able to just provide the same functionality for windows and OS X
@crigou - and NO, I don´t want to run windows on my mac - this is why I changed to mac...
You don't have to switch to Windows, but have it as a complement. That's what an Intel-Mac is made for. What a flexibility with a Mac.
This is a fail, Microsoft has failed.
I agree with mastige and several others on this forum its of great disappoint that UserForm is dead. It is a great shame I wonder what the real reason is.
This is a very disappointing announcement that UserForm creation is not to be supported going forward, having effectively ended after Office 2011. I have developed Excel solutions for my own medical practice that have been wonderful and reliable time savers, making heavy use of VBA and UserForms. My office is strictly Mac-based, including a highly reliable 2011 iMac, and I have zero desire to switch to a Windows system. When the time comes to switch to an M1 based Mac, it will be goodbye to Excel.
Here is described, by Microsoft, the Privacy and Security for Office Add-ins:
It would be interesting to know how other companies adapt their security policy to this.
Manuel Gutierrez commented
My company has disabled the use of add-ins as part of its security policity, which leaves me with no possible solution to the lack of VBA Userforms. It is essential to have some solution that does not depend on hosting the add-in on a server. I think your strategy of pushing towards the use of Add-ins does not contemplate the problem with security policies of most companies.
If you don't like Microsoft, why do you pretend to use their software products ?
What a joke. More compatibility by not adding compatibility.
Steph Beach commented
Looks. like a bit of progress. I'll be VERY happy when this is implemented.
Thank you in Advance
Thank you for your comment.
I must admit that you already showed us a usable way on latest November 24th, proposing to make use of worksheet cells (fed by ad hoc vba code) to replace the missing user form controls. You had a good thinking there.
David Swift commented
Wow Crigou you’ve actually come up trumps! 😊. Thank you!!
This will be a useful stop gap while they make their minds up what to do.
Screenshot of a programmatically generated UserForm object in Excel for Mac:
What is still needed ?
user form in mac please
Crigou, Thanks for the heads up about that other thread!
I didn’t realise there were other threads on the same topic. I guess if MS add them all up it could be a considerable number if requests. Who knows how many threads there are! If you know of any others please share 😉
Very interesting, what Oliver wrote on May 10th 2017 (soon 4 years !):
VBA has NEVER been completely portable between MAC/PC. However, this is one of the reasons why .NET has been written for OSX. However, that was only released ~ 1 year ago, and it takes A LONG time to re-write code of this complexity. Those people who think this will be re-written in less than 1 year is kidding themselves. Your best option for now, roll back to Office 2011 for MAC, and use that for the time being.... or run parallels and just run a windows version for the time being. Trust me, when Microsoft is fully compatible with OSX they'll fanfare it. Until then, continuing to complain doesn't get the problem solved (opening a support ticket with Microsoft is your best option for now, with enough support tickets, it will get higher priority to resolution).
Please consider the full discussion:
So Troll, It is interesting that you value the opinion of kid who is barely out of puberty so much, and yet apparently you have trouble understanding what he is saying. Still in high school, eh? First, let's qualify the "article" you site. It is written by someone trying to sell their skills as a teacher... Not a developer or anyone with any pull in Microsoft. Second, Aside from using the term "Ideally" in a way that makes him appear as someone in Microsoft with an agenda, he simply states what we all know is true... the two products are not equal. What he meant to say if you read the rest of the article is... "Excel for Mac is not the same as Excel for Windows; if you are a power user, you need to buy the Windows product." But he's a self-proclaimed educator and no one of any influence. I am completely baffled as to why you continue to harrass people here when they request a change from Microsoft on a site that Microsoft set up to capture such requests... Glad to see you made it thru the holidays though. I was a little worried about you sitting alone in your mom's basement. Happy New Year!
In this recent article on the subject:
one can read:
" Ideally, you have to use Excel for Windows if you’re a power user. "
Add the user-form functionality in Excel Mac please.
Excel sem user form???? Quem teve essa ideia??? Que ideia horrivel!!!!