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]
@Dan Battalion Could you let me know how to increase the font size in VBE? It keeps reverting to font size 11 of Menlo despite everything I have tried
2016 will not run most of my custom macros despite Microsoft's claim that it will run all existing macros. Are there specific functions that 2016 does not currently support? User forms?
omg, why i´ve uninstalled my 2011 version?!
Bill Earl commented
I bought Mac Excel 2016 (as with every version since 1985), and installed it along side Excel 2011. After trying Excel 2016 VBA, I have used only Excel 2011 since, and will not use Excel 2016 until its VBA is at least on a par with Excel 2011 and preferably Windows Excel 2016.
Please also restore the dedicated Mac Office VBA online resource that was unceremoniously deleted a couple years ago, or at least a complete and detailed description of the differences between Mac Office VBA and Windows Office VBA.
Although I'm very weary of Microsoft's repeated sabotaging of its own Mac Office products (starting with 2008), I'm looking forward to the restored VBA Editor some time in 2016. Please surprise on the upside this time. Thanks.
Giorgio Tassi commented
I will buy the 2016 version when it will include a "fully functional VBE" including user forms etc. Not before!
Sohel Sagar commented
Any update on the issue?? Does anyone know how soon are we going to get the update? :(
Excel without macros/VBA is no Excel! This was the problem with Excel 2008.
Larry Jenks commented
I'm guessing that my free evaluation period for Excel 2016 will have expired long before this project is completed.
Ted Barrera commented
Any updates on when VBE will be released? I can't get my macro from Office 2013 to run on Office 2016. Excel now gives me out of memory errors. Highly unlikely, considering I'm monitoring 8GB RAM free, and it's not a particularly heavy macro (it ran smooth as butter in Office 2013). Any reason this might be happening?
Akhtar Malik commented
Please bring back VBE (Visual Basic Editor) as it was in office 2011 or even better because without VBA editor the excel is unable to provide its functionality on MAC and it become only excel viewer. A full VBA editor is compulsory part of excel which will attract the MAC user to shift on excel easily and quickly.
One VBA feature that seems to be missing (and is therefore causing significant compatibility issues for me) is the ability to add custom menus to Excel 2016 for Mac via VBA. This is a critical feature for me to allow clients to access macros. Will this feature be added back in to 2016 for Mac?
Hopefully not just a port, but an upgrade ... the multi-window mode of 2011 is annoying, especially on a small screen. I have also always disliked the popup window that states the line has an error (I know it does, and I intentionally left it that way to move to another line of code).
I like the new window organizations within 2016, it just needs the 2011 features (watch, dictionary, autocomplete, syntax highlighting, etc)
Glad to hear that you are migrating the 2011 VBE to 2016. I purchased Office 2016 for MAC (subscription 1 year) as a vote of confidence. From a business perspective it is important for clients to show support in this manner...now - we wait patiently (?) for the finished product. Until then I work to develop in 2011 and test in 2016 - so far only minor detail level hiccups. Please keep the initiative alive.
looking forward to hearing that your work is completed, then I will buy Office 2016 for Mac
@Tim - sure thing.
@Jim (et al) - I'm going to change this request to be about making the VBE (the VBA editor) better, since I haven't heard anything from the community about Excel 2011 VBA or macros not actually running.
Tim Clink commented
Agree. I'm sticking with Excel 2011 until full VBA support, or at least on par with 2011 is re-introduced. I believe I read in a different thread on this forum that one of the development team spoke of ongoing efforts to add full VB Editor support back in on a future update.
Tim Clink commented
Dan, Thank you for the acknowledgement. I was prepared to stick it out with Excel 2011 due to the state of the VBE. This gives me hope that Mac Excel 2016 will get there.
Dan Battagin [MS XL] commented
Jim (et al) - there are two issues here that I want to separate out (for clarity, I understand that both may need to be addressed):
1. Running macros from Mac Excel 2011
2. The VBE (editor) experience in Mac Excel 2016
For #1 (running existing VBA/Macros from 2011) - these should all run, just as they did, with no compat issues. If you are seeing compat issues, please share what those issues are because they are bugs that we'll want to look into right away.
For #2 (the 'simplified' VBE editor). Let's be honest - it's not simplified, it's completely ridiculous. There were technical reasons for this (mostly the move from Carbon to Cocoa) but clearly we need to do better. The good news is that we're currently working on porting the VBE experience from Windows Excel (and essentially what was in Mac Excel 2011) to Mac Excel 2016.
So, again, please do let me know if there are macros or VBA that worked in 2011 that do not work in 2016.
absolutely agree with the idea
Excel 2016 must include a full version of the VBA Module. I (and my Team)use Excel (on a variety of platforms and devices) as the primary tool for Business Support and the VBA module for Mac is not anywhere where it needs to be - please ensure this is prioritised - this is already impacting on Business Support