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]
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.
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.
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.
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.
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.
Crigou is quite right - my office in the UK (a very large architectural practice) would not even consider Apple systems. They didn’t meet the stringent requires required and failed on software quality, networking and stability.
Try LibreOffice - free software, runs on any platform and I am told is as good as if not better than MS Office.
As a Mac user who is using Excel for entering Parish Records onto a database (FreeReg) I shall be moving over to LibreOffice spreadsheets when Mojave arrives.
Microsoft lost my custom with their hopeless updates system five years ago, and now they lose me on everything else.
In response to: “It seems to be that MS Excel neither wants nor cares to reimplement UserForms for Mac users. Unwise on their part, as more and more offices are using 365 on Mac platforms...at least that's been my experience.”
Yes - in the process of dumbing down their software so that it works on all platforms they are loosing custom to OpenLibre which does have a viable macro system. Is this the beginning of the end for Microsoft? Many companies my moving over to Unix based systems such as Linux and Apple, so it could easily happen.
Microsoft are I think guilty of mis-selling their product. Therefore They would be liable in the UK for prosecution. Time to pass this one to the trading standards authority.
I believe all customers that bought this crippled useless piece of software should either be given a free upgrade to the next working version or given their money back in full. The release of this product was dishonest - and not fit for purpose. It was in fact a scam.
Microsoft is not alone in having to pander to the huge pressures of releasing new versions to keep up with the opposition. But it is unforgivable to release a new "updated" version that actually does LESS than the previous one. Customers buy the new version on the belief that it is better than the previous and the fact is that this version is an enormous scam. Nowhere in the usual pre-release hype did it say "we've deleted the entire VBA functionality"
To correct this monstrous error MS should offer a "downgrade" to version 2011 immediately. They will loose customers otherwise.
I have just noticed that my post back in May (?) had a typo in it which makes the message a little obscure. I suspect the spell checker did the dirty on me with a surreptitious change...
The second para has the phrase "dumping down" in it. This of course should have read "dumbing down" that is to make something simple but useless.
I believe LibreOffice has a macro language if anyone is interested in a better product. I haven't checked it out yet.
This version of Excel is a complete joke. The ability to create useful macros and userforms is non-existent. Is Microsoft going to give us our money back? This product is not much better than the original spreadsheet - VisiCalc (saw it demo'd in 1978/9).
What really annoys me is the amount time and resources spent on "dumping down" the product so that the emoji fans can have their fix. This is no longer a professional product worth using in the office (or anywhere else).
We will still accept votes on this suggestion. Please note that this suggestion is not for VBA UserForms. There’s a separate suggestion you can vote for if that’s most important to you.
Some comments on the other suggestion indicate that clarification was needed, so I’ve updated the titles and description to be clearer.
Steve K [MS Excel]
Simon queries why we have to continue with paying for new version of MS which are incrementally worse than the previous - a payment for downgrading. You don’t have to - you can move to the OpenOffice suite - it’s free, runs on most OS’s and has a macro system similar to MS’s. the only down side is that it is not exactly compatible with MS VBA and there is a steep learning curve. I think the wise move is not to upgrade MS Office until they sort it! This may take a long time......
In Excel 2011 for Mac the Form icon is available by right clicking on the quick access toolbar (at the top) and choosing "Customize Toolbars and menus..." then select Data in the left column and "Form..." in the right which can be dragged up onto the toolbar.
In Excel 2016 for Mac it is not available. The quick access toolbar customization is in Preferences, but the Form icon has been deleted.
Why Microsoft feel they need to firstly change the method of finding these controls and then deleting some is beyond my comprehension. My motto has always been "if it ain't broken DON'T FIX IT"!
Now that the 2019 version is out are we going get a free copy (having bought the crippled 2016 version)?
I don’t think so.