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]
Just to add weight to Mauricio and others yes you can edit the code. I use my old Mac running office 2011 to design & create the form etc then code from office 365. Its a pain but it works one day MS might come to their senses. Lets hope so
You can edit the code!!! What I’m doing is use Windows to create the user form and write the code on Mac.
Why on Mac? Well there’re some differences between the ASCII, so I have found, that if I write the code on Windows, I always have some errors trying to run on Mac.
Thad Crews commented
Patrick, you mention you can use User Forms on a Mac, but you cannot create or edit a user form on a Mac (unless using 2011 version of Excel or running a Windows VM on the Mac).
I know you cannot edit the user form, but can you see or edit the VBA code associate with the user form? Or is the VBA code for the user form also totally inaccessible?
Sorry to contradict you, but there are major (and well-known) differences, in MS-Office, between the Windows and the macOS versions:
Patrick Raiford commented
Hey Oliver, just wanted to clarify your statement
You said that user forms will not run on Excel for Mac and that is not correct. User Forms will work on a Mac. I use one all the time on one of my spreadsheets. It’s just you cannot create or edit a user form on a Mac unless you use the 2011 version or run a windows version on a VM on the Mac.
Oliver keim commented
I can understand how you feel. I have similar feelings, specifically because marketing often promisses that Office works across the platforms - which is not exactly the case, which has proven evidence with the user forms.
I also spent a huge amount of time and effort to develop maximum efficiency, usablity and end user convenience into dozens of our user forms.
IMHO for the platform with best end user convenience (macOS) all this effort was meaningless. I have a feeling the non-support for user forms may be on purpose...
Here Microsoft can prove evidence if they mean what they say, ensuring end users have great experiences on all products, including their products running on macOS, iOS, Android.
It could probably be a good idea to include Apple, so to let them know that the user forms do not run on their platform and they may address this to Microsoft. Apple may have more power to make things happen than a user voice community which is not heard.
No reason for you to get so nervous. There is an unexpensive solution to save your 500-hours work: install Windows. I did myself legally download Windows 10.
Dan Herman commented
It's ridiculous that you now won't support any version of Excel that will let me keep using the UserForm I spent ~500 hours perfecting. Thanks Microsoft and Apple for joining forces to ***** the real users of your products. I'm glad your phones have super spiffy cameras, and your cloud services are fluffiest in all the world. But it leaves me with ****** off customers... which you seem never to care about.
please, please please! VBA user form function for Macs. ( please).
Oliver keim commented
Steve K, any update on this issue? The community is begging for a long time now.
BTW I would also appreciate XML support on macOS Office VBA. I would really appreciate the API would be consistent across the Office versions.
Please add the VBA userform function for Mac please...
please bring back userform and data Form on Excel 2019
Please add the VBA Userform for Mac. I have been learning VB and creating userforms on a previou version, upgraded and shocked that I cannot insert a userform. This was a massive feature and needs to be included asap.... please.... jamie
Hi Wei Liu,
You are right: the amount brought by each Mac user is the same, but the total amount available to MS for product development is much lower (lower market share of Apple machines).
Wei Liu commented
I don't understand. Mac users ain't paying one dollar less. Please bring back userforms.
I recently upgraded to using Office 365 and found out afterwards that there is not a way to insert a Userform in excel Mac for versions 2016+. This is a very large functionality that is missing only for Mac users. The worse part is that we are not able to revert to a previous version (2011) as it is not supported on the latest Mac OS leaving everyone dead in the water when trying to use excel userforms. Is this being prioritized?
Ive been playing with the form controls and think I may have thought of a way round. Its a bit circuitous though. There probably is a way to directly access the form controls in the code but as you say, its certainly very obscure.
The form controls have a right click "format control" option that reads and writes to cells or ranges of cells within a worksheet. The output is in the form of an integer in for example list boxes, and you could write code to feed or write from the cells that the form control is linked to.
The button control seems to be a simple way of running a macro you have recorded or developed. Option buttons write an integer to a chosen cell and can be grouped in the group box and work independently from those outside of the box.
If you had text or numerical values to input or output, this would be done in a cell directly through code.
Also by using spreadsheet functions like Vlookup, SumIf etc. within the cells referenced by the form controls, a lot of coding could be obviated.
Heiner, Ive found this with a few possible clues:
For example it says this:
---"Properties - I don't know of a button or keyboard shortcut, but you can drag the Properties window out of the VB Editor so it floats above the worksheet. The properties displayed are what is currently the active object in the VB Editor, not on the worksheet."
Let me know if you find anything else...
EDIT - Just tried it and the properties box doesn't seem to work with the sheet form controls in the way described...
@Will, you talk rubbish, why do we need windows. MS promised in there advertisements progress and the same as windows. But nothing is far from the truth. De Excel development department for the Mac at Microsoft is pure ****, at least the managers. We pay the same for both versions. If someone hurts you'r feeling, start crying. How many years are we asking for to be equal as the windows version. From day one. 1145 votes as of today. No they are busy with an iPad version. Yep, really important compared to a Mac version. iPad version is nice to show off, but the real work has to be done on the Mac.
Barbara: yes exactly! Thank you.
Heiner: I’m going to have a look... perhaps there is some spreadsheet formatting for the control object within the sheet rather than the code. A bit like locking a picture to float over cells or within one etc. Haven’t really used that much either though. Sounds interesting!
(At last a useful conversation!)