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 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
Mac Office 2004 was great. Mac Office 2008 was a disaster. The people that really needed the power of Excel didn't buy it. Mac Office 2011 was perfect. Obviously, Microsoft heard our requests for fixing the crippled Office 2008. Office 2016 is Office 2008 all over again. What happened? Did the entire Office for Mac 2011 team retire and get replaced? What we really want is Office 2011 updated for compatibility with the Windows version. Please don't give us a downgrade in functionality and tell us it's "new and improved". Please don't change the user interface for simplicity. Please don't "dumb down" the program.
It absolutly needs VBA. How can I read my files with VBA scripts?
When will be it possible Microsoft?
Geoff Lilley commented
Agree completely. Your use of the word "simplified" is a euphemism for "completely crippled to the point of useless" version of the VBA interface. There's no point in even trying. We can't record, nor debug, NOTHING. You just rendered it useless.