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 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:
If you look carefully some users may see that UserForm is coming back, its not all their yet but you can see the evidence that Microsoft are woking on it see:-
I work for both Windows and Mac environment depending on the department in use. Office for Mac licenses are more then 600 and honestly we stick on 2011 due to that limitation. We have loads of reports that are transversal between departments and using ActiveX forms and as they wouldn't work so we advice to maintain as it was. The company didn't go through and we stick with 2011 because of that.
You said it Steve Van Dellen « Adding Controls and setting all the attributes with code is surely painful«
That is the problem
Steve Van Dellen commented
On July 23 I posted a comment that, if you opened a workbook with UserForms created with Excel for Windows, the form and controls seemed to work just as they did with Windows and you could edit the UserForm with VBA, again, just as you could with Windows. In that post, I said you couldn't create a new UserForm from scratch with Excel for Mac so you had to have Excel for Windows to get started. It turns out that VBA in Excel for Mac CAN create a new UserForm. https://stackoverflow.com/questions/11519345/creating-form-programmatically-in-the-module-using-vba describes how. I think that code was developed for Excel for Windows but I just copied it into a VBA Module in Excel for Mac and it worked. I haven't done any more with it yet but I don't see why a person can't create any sort of UserForm they like now. Adding Controls and setting all the attributes with code is surely painful compared to doing it visually with the VBE but it does give us a way go forward without waiting for Microsoft.
p.s. Note that you MUST add "Microsoft Visual Basic for Applications Extensions" to the References for the workbook or the code won't compile.
On a Mac one can easily run Windows / Office as well.