Bring back a fully functional VBE (Visual Basic Editor for VBA)
Please bring back the full editor capability of VBE to Mac Excel 2016, like we had in Mac Excel 2011. As it is, the "slimmed down" editing experience of VBA is more like a notepad experience than anything - making it basically impossible to
* edit VBA from scratch,
* get syntax highlighting
* see a watch window
(Note: this title and description updated by Dan [MS] on 10/19/2015)
Hi All – The Visual Basic Editor was greatly improved in an update several months ago. If you don’t have the latest version of Excel for Mac, please go to Help > Check for Updates and update to the latest version to check it out. Thanks for all your comments and support for this feature.
If you notice issues as you are using the latest VBE, please let us know by clicking the smiley-face feedback button near the top-right of the Excel window.
Steve K [MS Excel]
How can you improve Excel for mac? Doing it just like Excel for PC.
... with cc to @BillGates
Ed Hansberry commented
I suggest we all express that bitter disappointment on its Twitter: @msexcel (https://twitter.com/msexcel)
David Blair commented
It's been almost two years since Dan said MS had started on this, but nothing happens. Is this one of those cases of "one part-time programmer working a few hours a week"????
Bill Earl commented
"Have a detailed discussion forum which as as many resources and useful procedures to preform complex and simple actions in excel on mac."
Not gonna happen... (unfortunately)
At least not on Microsoft's website. The best we can do now is support the few independent websites that support Excel VBA for Mac.
Microsoft had a fantastic site for Excel 2011 VBA but it was inexplicably deleted a few years ago. I wish I had downloaded the whole thing while I had the chance. This was (and is) intentional sabotage by Microsoft. And there are no books on Excel VBA for Mac. We've been cut loose.
I'm not blaming Dan Battagin of Microsoft. I believe he was overruled.
Akhlaaq Choudry commented
Have a detailed discussion forum which as as many resources and useful procedures to preform complex and simple actions in excel on mac. There are tonnes of resources for Windows, built nothing for mac. It should also have a service whereby i can post a link to something i want done for windows and someone will convert those instructions for Imac usage.
how do i do this in excel on the I~MAC . no idea!
J. Presper Eckert commented
I hope you are because I'm staying with Mac and staying with Office for Mac 2011 so I can do useful work with Excel VBA. This is a terrible decision Microsoft's made to deprive Mac users of excel vba. I've written tools for movie studios, condominiums, game companies, all using excel vba on the mac. Some, many, enterprise activities require excel and vba. NONE demand a Windows machine. I prefer, will always prefer Mac OS to Windows OS. Full Stop.
This new excel2016 for mac is the pits, i have reverted to 2011 and asked for refund for lack of performance. in addition the subscription business model is a rip off (in some countries they translate this in react).
Pls don't bring VBA to mac Excel. I'd like to watch them suffer a little longer. lol
So. To sum up the essence of this whole thread:
Bring back a fully functional VBE (Visual Basic Editor for VBA)!!!
Zev Spitz commented
Integrate the cross-platform VS Code into Excel. Vote here -- https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/20010145-integrate-vs-code-into-excel-at-the-same-level-as
It's really hard to understand that such a professional organization that has been #1 in the industry has how drawn us in to believe in the products you have developed will help us in our business and personal lives only to start taking away features that we have taken time and effort to learn. I would appreciate a response as to why your mission has changed!
Patrick Jonas commented
I strive for excelling lit see what happen, we take this on a test run
Ron de Bruin's page really helped me solve much of the problems and I am through now. Thanks.
Bill Earl commented
"Microsoft employees are bracing for layoffs to be announced Thursday"
I think Satya changed some strategy and priorities. Not to be cynical or anything...
Omar Gonzalez Portus commented
When will VBA be ready in Excel 2016 for Mac? A long time has passed and nothing yet.
Anyone know anything?
Pissed Off User commented
Thanks for the "upgrade" Microsoft... Courier size 10 font for my VB editing pleasure. Who in their right thought the ability to change the VBE font was an unnecessary feature?
The MacOS operating system isn't going anywhere. Get used to it and start developing for it.
This is an unadulterated attack on Mac users- nothing more...You had VBA editor now- you've lost it??? Really? My company gave employees the option to choose their laptop. Many have chosen Macs. It won't take much to choose a DIFFERENT office software. Get on board before you have NOTHING to hold onto.
Well, I don't understand why vba has been abandoned...again. Not mentioning, that I'm actually paying to be able to use access online, as Microsoft, that I am also paying monthly, doesn't provide me tha program on Mac. Be aware guys, Libreoffice is becoming very close, and it is free