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]
Autocoder 0311 commented
When I develop excel VBA for the MAC, I do it on windows.
I use VBA code to test for MAC or windows and change path formats.
Trail and error determines any formula compatibility issues.
Can you at least upgrade excel 2016 to allow cursor hover over a variable showing its content.
that would be a big help.
Bryon Karren commented
As to missing find/replace: Not being a professional VBA programmer my fall back is to create a macro to try and do what I want. I did this with find/replace. I highlighted the area I wanted searched and the returned macro did work: Replace all 'e' with 'x' in selected area.
Generally when it returns "ExecuteExcel4MacroSub" I find the code does not work, but this time it did. I have no idea what the various parameters mean.
' Macro3 Macro
Autocoder 0311 commented
Big Data Microsoft Office Solutions require MAC and Windows VBA support
Correct. No Find and Replace. This is basic spreadsheet functionality and it is missing. I paid all this money for Excel 2016 for Mac and I have to use the 2011 version to get any work done. Microsoft should really reimburse us back for a useless veresion of Excel 2016
Just switched to Excel Mac 2016 365 from a Office 2016 Windows version, as my Virtual PC was just not good enough for me anymore.
Unfortunately I discovered the poor functionality of EXCEL Max VBA, both the editor, but apparently also the functions. A simple thing af Excel.Range do not seem to work in Excel.Mac, at least not as it did in my Excel.Windows.
Anyway, the switch back to virtual pc is not an option for me, nor is a windows pc, so I am a bit stuck now.
Please bring back full VBA functionality - the 365 Mac versions could be fix a lot of issues.
Hugh McKay commented
There appears to be no Find/Replace within the VBE code module is this right?
It worked in 2011
Norbert Lesch commented
August 2016. I decided to change my business notebook from Windows machine to MAC PRO. Before I tested EXCEL on MAC like a typical user. It worked in a sufficient way. So, I did the switch. My mistake was that I didn’t check the VBA programming environment. After some days with my new MAC I wanted to continue programming in VBA. Shock! A primitive editor, no debug, no …. Unusable. After reading the comments in forums I realized that I have to program on a separate Windows machine and to spend many time with copies, versions control and so on between Windows and MAC world. I see since then all the comments from Microsoft that they work on the porting of the 2011 MAC programming environment to 2016 MAC version. But, there is no visible progress (also not in 15.32.0) and no announcement about a concrete delivery date. I decided meanwhile to go back to Windows machine as early as possible and to warn professional EXCEL users. Maybe I fulfill by this behavior Microsoft’s expectations. // Regards, Norbert
Jim Gordon Mac MVP commented
The current VBE continues to be an embarrassment for Microsoft. I understand there's a lot going under the covers, but please understand this is a blocking issue for Office for Mac and deserves high priority.
133 comments to date but only one from Microsoft's admin on October 2015. This is obviously an "Excel User Voice" site, but just among users. I guess no one in Microsoft has time to care about users. I guess there must be much more important things to do.
I have a suggestion: If all the users who posted questions here, that have never been answered, click on the "Tweeter" button up here and share this thread with @BillGates, maybe, just maybe, the "user voice" will be answered.
Todd Forney commented
Subject: How can we improve Excel for Mac?
How about a fully functional VBE? What I got with a costly upgrade/subscription to Excel 2016 for Mac is better than useless, but not significantly.
How about PowerQuery?
Shall I go on?
Phil Greenwood commented
Like most on this page I do not feel I'm getting what I paid for. It may be a big job but you started in October 2015 and it's now March 2017 just how much resource are you putting into this project?
Bill Earl commented
If this VBE deficiency is deliberate neglect by Microsoft, which is what I suspect, don't expect any information. Incidentally, "Support for Office for Mac 2011 ends on October 10, 2017", the last version that does have reasonable VBA support (although not as good as the Windows version). Mac Excel 2016 is not usable for my purposes. Microsoft should have the decency to advise its customers now on the future of Excel for Mac.
Hi Dan Battagin, are you still working for microsoft? or are you fired??? I am sure that everybody curios about whats going on this project... Any information????
Dane Barber commented
If there is anything I can do to help facilitate a new VBE please let me know. I know it's not a simple task and MacOS works as a sandbox environment, and I'm sure it changes every update they do. I'll learn whatever language you guys are using and contribute in any way I can to help get this done.
MArco V commented
All of you in microsoft are bad hombres!!! It cant be true, Excel was created for MAC, so why Excel for MAC version lacks of VBA editor??? I spent last weekend trying to figure out what the **** happened!!! I hope the new editor be avaliable before next office release
Andreas Probst commented
Anything new?? Just bought my copy, just to discover there is a big black hole!!
And the post of the MS guy is over one year old!
hm bad news everyone. M$ screws Mac users
To be clear, I'm not defending M$ on this point, but how often do you EVER see a product that tells you about what is missing from it when you buy it. Technically, its also not missing, it is just ridiculously stripped-down (again, I'm not defending them on this point, just making a point). I'm actually surprised there isn't a class-action lawsuit against them on this point.
Oscar Abarca Pena commented
You wouldn't buy a car with only two wheels would you? Microsoft should let know the buyers the version its incomplete and highlight the issues.. so you can decide to buy it or not...