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, 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!)
Heiner Lieth commented
I have noticed over the years, as I was holding my breath, that at various times a new versions of Excel would have some improvements without any announcement. So I thought just now, let's see what if perhaps something has changed. Well there still is no Form editor or designer. But oh look: MacOS Excel 365 version 16.39 has visual controls on the developer tab ribbon (I guess they have been there but to me they always seemed do nothing). So I just now I guessed that I could perhaps mimic a userform with a sheet with those control dropped into place. I tried it and it is barely usable. The is no Frame control to group them. Groupbox (for grouping checkboxes or option buttons) appears unusable. Or perhaps whatever is intuitive to the programmers is not intuitive to me. Is anyone aware of a tutorial for how to use those control?
Barbara Ledo commented
Tall and short adults pay the same price because their clothes does the same effect. When MS sells Excel for MAC users, they must sell a program with the same features (so it will work perfectly for everyone).
I think we should come here often to show developers that we're alive and still waiting for this. Please, we need UserForm!
Will, Barbara, Heiner, Mauricio,
This discussion is just beginning to become interesting and constructive.
Will, don’t go! Crigou (check out the obscure Migou as one spelling of Mi-go; a term for the Yeti, the legendary and rarely seen “wild man”) has his angle and it certainly always seems to be off topic. I have been ignoring his interjections for years - but to be fair things may have been different without your kind apprisement.
A couple of things then;
1. I’ve been using excel vba for Mac for years now to create a few cross platform workbooks with some quite complex useabilities. The user form was probably one of the first elements I made use of. Although activex was never available for Mac, for my uses including some very functional userforms, I always found a cross platform workaround on the net.
The last non subscription version of excel that did have the user form was either 2011 or 16. Not sure which! Anyway 365 doesn’t have it as we know and it’s native file versions I believe are quite different being xml based.
So on Microsoft’s side, the commensurately required Mac based ground up rebuild of an application like excel would take a huge amount of work and time. And Mac programmers aren’t generally really keen on working for Microsoft!
Having said that, it’s not really fair to hold clients to ransom because of their profession. My design based work for example requires the use of a Mac. But I also believe excel and vba is required to maintain a professional edge in my particular branch of the industry too. An analogy might be that tall adults don’t pay more for their clothes than short adults just because they use more cloth and take a bit more work to make. So why should Mac users?
Frankly, the Office suite has become so intrinsic to the running of society in general, it should be made mandatory to keep it developed in a cross the board and up to date way. It’s possibly as important as road repairs. Maybe it should be nationalised! (Not really serious, but hopefully it shows it’s no laughing matter. Livelihoods and industries have built themselves on these technologies.)
In conclusion, I have a gut feeling based on the recent deceleration in product improvement that we may have a long wait.
So in case it got missed before, my most emphatic vote Is for the userform to enabled natively on the Mac.
Sean Magula commented
I agree with you 100% Will, Crigou takes away from the nature of this thread/forum, "How can we improve Excel for Mac". Why don't you change your whole environment to Windows and run Excel...has nothing to do with how to improve Excel for Mac. It detracts from the intended purpose.
I have read many of the comments, and everyone is right on some points, what needs to be made clear, is that Microsoft has not put the userfoms on Mac (for forgetfulness, lack of resources or lack of interest, etc...) Of course we can use other resources as parallels to run Windows virtually, but the fair thing is that if we pay for a service, we revived the full service (all excel).
Heiner, Point taken. It’s just frustrating that every time someone makes a post here Crigou jumps in and tries to explain the inner workings of Microsoft’s software development and their business model, when he clearly has no real information to back up his claim. He sends them to third party sites that are generally conjecture as if we’re all ignorant. It discourages folks from participating in the conversation. My goal is to make it as painful for him to post here as he’s attempting to make it for others. If it means that I have to call a person who is actively trolling a troll, so be it. What I don’t want is for folks to come here and think that he’s speaking on behalf of the moderators. His comments are irrelevant to the conversation.
I take it that “yourself” is directed at me, but I don’t identify with my username. My online persona won’t be upset if you think he’s a bully for not lying down while this guy calls us all ignorant.
Nor do I assume that the person signing “Crigou” identifies with their user name... That said, the persona “Crigou” needs to be discredited. “Crigou” comes here with the sole intention of making others feel ignorant. Crigou should take his comments and post them where they are relevant. The title of the blog might be... “How to design vba forms on a Mac” vice “How can we improve Excel for Mac”.
I would prefer if every time Crigou showed up, someone other than me reminded him that he’s trolling. Or if a handful of you request that I stop, I’m amenable. And we can allow this character to continue to bash folks who come here asking for a feature.
Heiner Lieth commented
Responding to Will: that is what I have now. I run a Windows Virtual machine on my Mac, with a paid copy of Office and Windows solely so I can teach my graduate modeling course where I teach students how to use the awesome tool of VBA within the Excel software (which they all use for data manipulation).
I would suggest that we not take any comments by anyone personally, nor resort to name-calling, nor making any statements about other persons. In the long run such comments just reflect badly on yourself as they contribute nothing to the discussion.
Barbara Ledo commented
Apparently he is a seller from MS. Doesn't make any sense he keeps coming here to discourage us to ask for something to come back.