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]
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.