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]
I will return office in the next 30 days if this feature isn't added back.
Please get via user forms back. I bought office for Mac just to get back working with excel via. I really need this feature. Thanks
Patrick B. commented
I'm so irritated to find this function mysteriously missing. Please add userforms back.
Tristan Halford commented
Please can we have UserForms put back into Excel for Mac.
It is not true that LibreOffice is quite free. On their web page, they wish us to donate some money:
Nothing is free in our economic system: the LibreOffice developers also have to finance the numerous working hours.
I have a new MBP running 14.14.2 I also have Office 16.21 (181219). If I go to the VB editor I have a basic Use Form it does not run very well at present but it is there see also https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_365hp/userform-for-mac-2016/74bd553f-4d13-4724-82c1-c707fbfdb900?messageId=c00a6831-2e8d-43a9-a5d4-e5a280ba9410
I do NOT work for MS but do you VB extensively I'm sure its on the way back (Please Please )
I think the UserForms is coming, but there are some troubles. If they accidentally published it, it exists. Of course it is not a guarantee. MS removes working pieces from Windows products also. Such as they removed VB from Office Powerpoint years ago just to come back with it later..
Here is LibreOffice for MacOS https://www.libreoffice.org/get-help/install-howto/os-x/
David James commented
Well done - congratulations you have joined the growing army of Microsoft independents! MS really do need to reconsider their policies or they will continue to loose custom to other software developers.
I moved to Apple and then to Linux (because Apple doesn’t have adequate “Office” software) and now use LibreOffice.
I gave up and converted all my macro-enabled spreadsheets to LibreOffice. A bit of work to learn the new interface, but it all works, including the equivalent of Userforms, and its all cross-platform - Windows, Mac and Linux. And its free!
On this forum
Jon Acampora did write what follows:
You can run userforms on the Excel 2016 for Mac. They will just have to be developed in either a Windows version or Excel 2011.
Better than nothing, isn't it ?
Created UserForm In VBA (Mac Excel 2016 v16.22 (190101)), Ran the UserForm (Run => Sub/UserForm), after running it Designer Mode of UserForm Disappear. So I am not able to edit the form anymore, How Can I get the Designer Window back? There is an Option Designer Mode under Run (Run => Designer Mode) when I am selecting it, it is showing blank for the UserForm,
Thomas Compter commented
Please please please put userform support back in.
Martin Busch commented
Please add Userforms on Mac Excel 2016!!
But Office 2011 is no longer supported on Mojave:
Paul Harrigan commented
If Microsoft wants to see a huge spike in the uptake of Office 365 for Mac, all they need to do is implement the faciity for creating and altering User Forms in Excel for Mac.
The day this happens I will buy the product like a shot. Until that time, there is no point in upgrading since I use User Forms extensively.
Another Office 2011 for Mac drawback is that powerful bulk mailing wasn't possible yet:
Bill Earl commented
Although I have Excel 2016, I still use Excel 2011 due to its better VBA. I won't consider Excel 2019 until its VBA is complete, preferably at least equal to Excel for Windows. I've used Excel since version 1 in 1985.
When still using Office for Mac 2011, there are serious and potentially harmful security risks: