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]
The official post Max recorded yesterday looks like it's on its way - GOOD news - fingers crossed... As my lovely big iMac screen has just gone phuut I was about to ditch the Mac experience because I am fed up of reverting to an old Windows laptop to do my Excel development. I may just wait a little longer before switching back.
Mike McCormick commented
It has been almost 2 years since Dan Battagin's "Good News" comment. What is the status?
Looks like MS is going to bring VB Editor back to Office for macOS.
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?