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 the suggestion and for the support of this feature. If you meant to vote for the Data Form, which is different than VBA UserForms, please change your vote to that suggestion instead. From reading the comments on this one, it seems that some clarification was needed.
I updated the title and description for this one and we’ll continue to monitor for comments and votes.
Here’s the link to the Data Form suggestion – https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/17930662-restore-data-form-functionality
Steve K [MS Excel]
Please restore the IserForm functionality to Excel for Mac OS users!
I have just changed to Apple under duress and now there is no VBA Userform geez wayne, I spent quite a bit of time creating and writing code for a user form on my PC only to find it doesnt work on my mac, not happy, nearly brought me to tears after all my hard work!!! Please put it back, soon.
Or at least tell me how I can use this file in Excel 2016
Sten Helge Nilsen commented
This update is a c..p. What "genius" character in Microsoft decided this??? VBA UserForms back NOW!!!
UGH I've been trying to get find where to build VBA User Forms for 90 min before finding this search result. Kill ME
Just evaluating Office 2016 (365) for Mac. We have Office 2011 on all our machines still. Discovered that creating VBA UserForms is not supported. Upgrade killer. Also, Office is not supported in Visual Basic Study for Mac, so work-arounds for the future are limited.
I just spent hours to search for userforms before landing on this page. What is our suscription to Office 365 worth if we cannot use the product to work?!
Please fix this asap, thanks
This is a critical business use case for continuity and business productivity.
I must be added.
Product development and product engineering - this is a requirement and an absolute need!
As described by others on here - userforms for the MacOS version of Excel. I'm using a mac exclusively and trying to complete a project for a customer that uses windows.
I can't create the userform necessary and can't travel the distance to their office to use a windows pc to create the userform, to return home and then complete the code..!!!
Gregory Boudon commented
I've worked all my life on PC and just turned on Mac. I'm now stucked with that poor Excel version. So disapointed. Please update userform. How could you have removed that key option !? Plese help your clients, we spend enough money for your products.
I am definitely voting for the User Form. I work with many who find spreadsheets difficult to navigate spreadsheets with many columns and need to enter many rows of data in batches. User Forms make this much easier. Please bring back User Forms.
Essie Djafarian commented
This is an essential part of excel. With more financial institutions using the Mac OS and the fact that these 3 programs were essentially developed on the Mac, it is unbelievable to see that there should be a difference between the Mac and the PC version.
We have supported Microsoft all these years and now we are stuck because the most essential pieces of this software that we have used all these years is missing, because of “I don’t know what?”
Please fix this essential part as it is very important.
Thank you for your support and attention
i literally cannot complete my homework because userform is not on excel mac. I am failing my classes because of you microsoft please get it together
Especially since User-Defined functions are one of the big reasons to use VBA in the first place. Agree, time to take MS to the standards authorities for shady sales activities.
Please re-instate UserForm in Mac 2016. Pretty please. Thanks.
We need an easy method of sending an Excel (Office 365) worksheet attached to an email. The email service can be Apple mail or Outlook.
Frank Wouts commented
Indeed please bring back add UserForm and editing back in ALL Office 2016 products where applicable.
We just updated our Apple clients from Office 2011 to 2016. I wish we had not....
Office 2011 apps are not available anymore with Office365 subscription. When one thinks about it, it's actually quite ridiculous...
Jose Geraldo commented
UserForm in Mac Excel 2016, Please
Jose Geraldo commented
David James commented
Microsoft are I think guilty of mis-selling their product. Therefore They would be liable in the UK for prosecution. Time to pass this one to the trading standards authority.
Just wasted a day searching for user forms in VBA on Mac Excel 16.10.
Without forms, this is NOT VBA.