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)
Good news. We are working on porting the VBE (VBA Editor) from Mac Excel 2011 to Mac Excel 2016. It’s going to take a while (it’s a big project) but we’re working on it.
How fully functional is this compared to Windows?
Bill Earl commented
When the newest version of Mac Excel VBA becomes at least as usable and powerful as Excel 2011 VBA, I'll upgrade, but not before then.
And where is the removed-since-Office-2011 Relative Reference Record Macro that makes VBA worth using?
Dan Moldover commented
Glad to see this is finally included in the latest Office 2016 release. Thanks!
Jerry H Titel commented
Please bring back macro protection in Mac Excel 15
Bring it back!!!
Poor quality is Your brain.
MAC is useless system for dummies. Don't understand how people can pay so huge money for hardware dedicated only to twitter and facebook...
If You need work with MicrosoftOffice, ORACLE databases etc.. You need to buy normal computer, with normal price, with twice better performance than useless Mac.
If Your goal is work well with Excel, sell Your Mac (or throw it away through the window), buy some normal notebook or desktop, and develop most awesome VBA Macros for Excel.
Buy Mac, and then cry me like a river, that MICROSOFT OFFICE doesn't work well...choose is Yours.
c'mon this is just continuing the tradition of poor quality microscoft
Nick M commented
Is there going to be a solution to this any time soon? This post is two years old now.
Please please please make a capable VB Editor a reality before support for Excel 2011 ends.
@Amanda, here's all the info on the Insiders program.
Amanda Marcy commented
Schweib - is Insider Fast a BETA environment? How do we get access?
Hi all -- Insider Fast just went live with the new VB IDE. Please check it out and report bugs to us! We hope to ship it for real early next month, so we'd love to have your feedback ASAP!
David B commented
Please try to keep features between Windows and Mac equal! Huge gap. Need Power BI as well.
Jorge Aguayo Cabrero commented
My only prerequisite back in 2011 in order to shift from Pc to Mac world was VBA for excel, a few months ago I changed from 2011 to excel 2016 and with the actúa Ui I'm sad every single day
Bao-Tram Ton commented
Mac and Windows Excel editions should work on aligning capabilities and features. Working for IBM this summer, there was a huge mix of Mac and Windows users. Those with Windows had to dumb down their excel dashboards and charts so that Mac users can open the same file and navigate the views. Full capabilities for VBA and Data Model/PowerPivot are two functionalities that set Mac and Windows Excel oceans apart.
David B commented
If all Mac users wanted out of Excel was a simple spreadsheet, we could use Numbers. But VBA is crucial to any utility I have for Excel.
agreed. Doesn't make sense for Excel to become less and less functional with each update...
YES PLEASE MICROSOFT