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]
Guys, it seems to me that the only way to move this project forward is to put some pressure on Apple instead of Microsoft since the latter obviously doesn't care about Mac users...
David Durham commented
Until that happens I must continue to the older version. Why pay for Office 365 each year when I can't use it due to the lack of VBA Help?
years to have the full functionality in VBE!!! no simple search capabilities and many others that are basic for Visual Basic development! We are trapped in Excel 2017 for MAC!!!
Is it so difficult to update simple things like text search or you don't want to update for MAC?
MArco V commented
No matter if all of Mac Users complain about VBE lacks on Excel.
Microsoft does not mind.
VBA has NEVER been completely portable between MAC/PC. However, this is one of the reasons why .NET has been written for OSX. However, that was only released ~ 1 year ago, and it takes A LONG time to re-write code of this complexity. Those people who think this will be re-written in less than 1 year is kidding themselves. Your best option for now, roll back to Office 2011 for MAC, and use that for the time being.... or run parallels and just run a windows version for the time being. Trust me, when Microsoft is fully compatible with OSX they'll fanfare it. Until then, continuing to complain doesn't get the problem solved (opening a support ticket with Microsoft is your best option for now, with enough support tickets, it will get higher priority to resolution).
Bryon Karren commented
Unfortunately there are also incompatiblities between Windows and MAC besides the editor. I ported a large VBA project over to MAC and found there were a number of statements that I had to change for the MAC. I did this using the "if MAC" statement to have a PC and a MAC version of certain parts of my coding. In addition there were some areas within pivot tables that I could not do on a MAC with VBA, or for that matter on a MAC pivot table that I could on a PC pivot table. In the end this made my ported version unusable. Of course these happened to be in the last module that I converted! Ideally it would be nice to be able to have a common MAC/PC VBA output that worked on either.
Further to Steve's post, I would have thought that Microsoft's Visual Studio Code (for which there is a Mac version) would be ideal as the VBE editor for Excel (and the other MS Office products). If this could be adapted for VBA, it would provide a universal editor, as Visual Studio Code is already a Java Script editor.
I agree with Steve, VBA already runs on the Mac, it's just the VBA editor, Form Editor, and debugging features that are missing. Surely after 18 months some progress has been made???
Can we expect to see something soon?
Dan Battagin, I know you're probably busy (as we all are), but I hope that you could provide some update? Is it possible to release features in a phased rollout?
Looking forward to your positive response.
Steve Mazdeh commented
Is there anyway to create an editor add-in to replace VBE?
Steve Mazdeh commented
How soon will it be ready? Can you prioritize features and release them in your updates.
Debugging and line number should be high priority. Right now the VBE is not even a good editor.
I have developed a workaround for search, but not for debugging. In 2011 version you could move
the debug pointer to previous line and re-run that line. Now you can't. That means I'll have to re-run the whole script. My Excels are handling 6tab each around 1000 rows x 30 columns of data. They do calculations and generate reports in another Excel workbook on the fly. Each run can take anywhere from 10-30min. It is very hard to debug new issues showing up from time to time.
I don't have access to 2011 anymore. VMware is failing to install windows 10 (windows 7 installed amazingly without any issues but it is now discontinued like Excel 2011), which now I have to debug too.
Any way you could speed up release will be greatly appreciated.
Totally agree. Even simple things are not the same. Can't even see a Print Preview that I can read on the screen, let alone other more complicated things. The Print Preview Full Screen command doesn't appear in any of the command lists for Excel for Mac 2016 to attempt to add it to the quick access toolbar. The only way that I can see a readable preview is to use the PDF option, view it in Preview, and then examine it, make necessary changes, repeat and select the pages I actually want to print. Lots of extra steps that used to be so easy when I worked on a PC - extremely disappointing, not to mention a waste of time to accomplish something that used to be a piece of cake.
Well, I'm not waiting any longer, am using Python now... very efficient/fast and I can avoid excel completely. Big disappointment that a company such as MS can't get it together... interesting case history for those that want to study the inefficiencies of big corporations perhaps. Ciao.
It's been over a year since you commented on the post.
Is there any progress? Why is no one updating us?
José Geraldo S. Machado commented
The lack of respect for their Office for Mac users is evident, charging them the same value as office for Windows, but delivering a baseless product to work with. This is lack of respect for your customers
P.M. Mason commented
Frankly I think Microsoft don't care. There's no competition so why bother. Plus they want us all on Wndows. I hate them but have few choices
José Geraldo S. Machado commented
Some kind of progress or outlook statement would be good customer service...
The way the entries on this site are censored (read the **** mask in my post) already tells me that this is not really a credible platform ... too bad that Microsoft is not listening to its customers (even though the forum is called "uservoice" ... the **** was intended to read C R A P ...
Excel for Mac has a VBA editor which is total ****. The VBA editor in Windows is better (although with latest upgrade the help function has been completely removed and replaced by a link to www, which makes it totally useless when working off-line (on a plane for example). I am paying the same price for my Office products, and Excel was BORN on a Mac back in 1984-1985, so why is Office so blatantly discarding their Mac customers ??? Why can't I use VBA User Forms on Excel 2016 for Mac ??? (just as one example) ??? Why can't I access the object model for VBA the way I can on Windows ??? This is an outrage ...