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 couldn't agree more, editing/creating userforms is essantial part of VBA on excel. And I paid the same price than a Windows user...
I think editing/creating userforms is essantial part of VBA on excel and has to be high priorty to implement back this feature to excel. Otherwise many ios users may abandon to use mac. it is not challange but Microsoft should assume it as a recommend and request.
While the economic argument does make sense, the problem is Microsoft don’t expressly advertise the product as being inferior to its Windows counterpart. If they provided a feature chart of Mac vs Windows, and allowed the purchaser to make an informed decision whether or not to buy it, this would go a long way. The fact it was included in older versions, and now removed without notice, a reasonable person would expect the feature to remain. This is likely the biggest cause of frustration here, Microsoft failed to set expectations. It’s good to hear that it is improving and perhaps it will be added later. I also hope the same is true for the perpetual version.
David Swift commented
Im no zealot for either faction. As a creative person I find the Apple interface doesn’t distract my flow and for sure I’d like to see this functionality too.
HOWEVER Mac users! Don’t lose hope; I believe, with good reason that we are not being ignored and shut out of that great thing that makes Excel so useful - VBA.
One example of development having taken place in this area is that my old user forms all work perfectly in v16.33 of 365 for Mac OS.
Therefore all I lack is the ability to create a new user form.
Now, a couple of years ago vba for Mac in 365 had even less functionality; again there was the usual kerfuffle over what should be done. Today though, we have a far more functional 365 vba than in 2016. My userforms and scripts don’t stutter or crash any more! This is one thing that indicates MS are hard at work developing for Mac OS. Even the negative comments to date haven’t stopped them at this work.
Next they are actually asking us what we would like to see in VBA. Clearly this is a question with a purpose; to continue developing! It’s therefore a natural progression that userform functionality will become available for Mac users in due course. Additionally MS won’t comment on it or make impossible promises because it’s a waste of energy and increases distrust even more than saying nothing.
So I say just look at the history and extrapolate a logical positive expectation into the future.
I’d say that it’s on its way...
So airbear, you’re new. Crigou is our lonely troll who tries to get folks to talk to him. His grasp of software development and business models is a bit under-developed. I think he’s looking for friends, but you can tell by his language even here that he’s a bit awkward. Thanks for the comment. This forum is designed to tell Microsoft what we think they can do better, and features we’d like to see. Our sad little troll doesn’t seem to grasp that concept either...
“Welcome to the Excel for Mac forum! This is the place for users to send us suggestions and ideas on how to improve. To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel.”
Don't you forget what follows ?
Assume that, for any reason, Office for Windows and Office for MacOS are two distinct software product developments. And if any MS-Office user would pay for instance 100 $ for it, independently of his platform, then, due to the much lower market share of the Mac users, the development budget for the Mac version would also be lower. This would explain why the wish for identical capabilities cannot be satisfied. Obvious economic reasons.
I like the comment from someone in regards to Office 365. Microsoft advertises Office 365 for Windows and Mac OS at the same price. If the Mac OS version is less capable (imho crippled) then surly a lessor product would cost less.
Custom userforms is often a primary function of my solutions for the other business units I support. The update to the rest of the VBA environment on OSX is a great step in the right direction, but I feel that userforms should be very high on the priority list as this makes many of my current solutions incompatible across platforms
Lee Townsend commented
What happened to customer satisfaction? Userforms are critical for my Excel development.
Najwa Rahal commented
Please add Data Form Entry to Mac.
How come it is not available ?
Keir Ryota commented
Could you ms just allow mac users to use it? i know it's just the matter of commenting out few lines.
Scott Marshall commented
I agree with you! This function would be wonderful!
Please add this to Mac!!
David James commented
In response to Rob, this is common with a lot of companies. Just look at the camera industry. A new camera is developed which has all the functions you need and within a couple of years a new version is brought out With some functions missing. This is endemic in our society today and it is killing the planet. It also loses customers. I have stayed with v2011 as it is the full version. Excel 2016 and 2019 are dumbed down versions and as such are scamming the customer. We should have our money refunded.
Typical Microsoft mentality, put something out that works and then upgrade (if you call it that) by removing features of previous versions. Just to make a buck!
What is the purpose of creating new versions of Office (2016 and 2019 Dutch for mac) when not all the features of previous versions are present?
With Excel 2019 VBA for mac it is not possible to use userforms and where is the option design mode in the Developer tab?
I regret to have payd for this Office.
Not “Respectable”. “Laughable”. The forum is “Excel for Mac”, not “Excel for Windows” on a Mac. You silly guy, you’ve baited me into talking to you. Do you feel acknowledged? Somebody talked to you today... Sorry, no time for more. Got to sell my car; I’m looking for a radio with different features.
Sean Magula commented
The troll is back. Been awhile. Maybe this post just fell off of his list. But alas he will not rest until someone hears his vitriolic campaign against macOS. Much sadness. Merry xmas grinch.
Do you not see the contradiction in your statement? You have to programmatically ADD to the program if you’re going to improve it. If the community provides feedback saying “you can IMPROVE Excel for Mac by ADDING UserForms,” telling them to use the Windows version is just telling them to go use a DIFFERENT software that runs on a DIFFERENT OS. Being able to add a different OS to Mac does NOT fix nor improve Mac for Excel (see the title of this forum).