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]
Do we build websites & databases, or Microsoft Excel's VBA UserForms? It was a decision we had to make.
I still develop in Excel's VBA. It was the first language I learned to use, 19 years ago.
I've moved as much as possible to Google Sheets. No VBA support for creating and editing UserForms was the straw that broke the camels back at our company.
The internet is pretty popular in 2019. In the USA, more businesses use the internet than Microsoft.
Microsoft choosing this route, forced us to alternatives. The company is catering to the government(s) sector, that do not have to exchange goods & services for $. Apparently, Microsoft is all in on Asian governments.
Lead Data Architect
This feature should be added to Excel 2016 as well as newer versions. People who bought 2016 thought they were buying an UPGRADE on 2011 but were scammed. If this is not possible then we should be able to get a FREE upgrade to the current version when it includes the various features removed in 2016.
Pigs will fly before any of this happens.
May be in Excel 2019 ?
Ron Abraham commented
When will the User Form be added to Mac Excel 2016?
What you are experiencing was already known about 2 years ago:
when Jon Acampora wrote:
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.
So bad about Excel on the mac.
I have an old form that still works, but I can no longer edit it
Furthermore, no Extended Support for Excel 2016 / Mac seems being defined:
Robert Frießleben commented
Tomas Ormeno commented
In response to Crigou - yes, Libreoffice does implement equivalent UserForms in its macro language. I have converted all my applications and abandoned Excel for Mac. You can use Python and other languages as well as Basic too.
I just found a discussion
in which Microsoft position about VBA on Mac is clearly expressed:
" … Microsoft glossed over this huge step backwards with the statement that you should be developing code in Windows VBA, and just using the Mac VBA IDE for testing and debugging … "
Use Libreoffice instead of MS-Office ? OK, fine. But are we sure to have in Libreoffice something equivalent to UserForms ?
Thank you David James, for your good ideas. Now, assume that, unfortunately, for any reason, Office for Windows and Office for MacOS would be two distinct software product developments. And if any Office user would pay for instance 100 $ for it, independently of his platform, then, due to the much lower market share of the Mac machines, the total budget for the Mac version would also be lower. This would explain the "reduced version" evoked by David James.
It has to be said that the main reason why Apple never had a larger share of the market was due to the simple fact that their own versions of Office (and other software) were toys compared with the real thing. Microsoft has always had a strong commercial following and it could easily “command” the Apple community as well by making the full version of Office available “on a Mac “. Not doing so encourages Apple users to use software such as OpenLibre which has a macro facility - not wonderful but better than what MS are offering at present.
OK, but on his side, a wise boss, naturally pragmatic, and actually needing full VBA on Mac, would never give up to also run Windows on that Mac, only for personal anti-Microsoft ideological reasons. MS know that, too. Then no many professional customers are lost in the game.
I agree - profit is the driver in any organisation - but not at the cost of losing custom. This feature is central to the way Excel is used by many companies and Microsoft will lose custom on this one.
Fortunately, most complaints in these discussions aren't of professional nature. As a matter of fact, any responsible boss wouldn't accept to wait several years for a workable solution with VBA.
Tania Monc commented
Please can we have UserForms put back into Excel for Mac.
All what is undertaken by any company (Microsoft, Apple, …) is deliberate and guided by cost / benefit minimizing.
It's been three years... I think the reason is either
1. Microsoft deliberately down grade software designed to run on Apple equipment
2. Microsoft are incapable of producing a version which runs on Apple equipment
3. Apple have made it difficult or expensive to to make this happen
4. Microsoft want you to buy the 365 version and make money on the license fee
5. other (you choose your favourite conspiracy theory)
The bottom line is Microsoft are charging full price for a crippled version not much better than Apple's Numbers (which costs a whole lot less). Microsoft are clearly not interested in its customer's requirements.