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]
What's the status on this? It's over a year now after Dan's response.
I'm sure many are still waiting to upgrade from 2011 to 2016 until this is resolved.
Having a workable Visual Basic Editor in Office 2016 that has a few more features than just typing would be nice. We're close to two years down the line with this and still not close to Office 2011 for VBA capability. I'm an optimist though. I'm sure you'll put some effort in before everyone buggers off elsewhere.
Bill Earl commented
Actually, Dan gave an update on June 28, 2016:
"Hey all. We're still working on this - making good progress, but still a bit to go."
is there any progress? any estimation, when VBA editor will be available with full function environment?
No news since October 2015 from the Dan the Admin :(
klaus allimant commented
project manager please give us a date!!!!
Too bad. I'm looking for 3rd party solutions. Is there anything you can do in Excel that can't be done in a tool like R?
VBE is a joke; wondering if I should be surprised that such an incomplete system was put on the market. Buyer beware.
Jim Gordon Mac MVP commented
The current VBE is exasperating. I'm ready for the new one.
BTW, Excel on MAC is looking better and better, thank you for your efforts...
When can we expect to see this working properly? I am trying to create products that are compatible on mac and PC and it would be great if this was fixed.
Atul Sharma commented
Sadly, this is a recurring issue. VBA was a core feature of Office 2004 (Mac) and dropped in 2008. Restored in 2011 and now weakened. I think Microsoft is telling us something e.g. use Windows. Having lost a huge amount of invested effort when Office 2008 was released, I stopped working with MS products in favour of other cross-platform solutions. I am sad to see the attitude hasn't changed.
@Arturo Sanz - My guess is Office 2020.
Arturo Sanz commented
Any estimated time to have this done?
Steve Coan commented
Weak sauce. I'm going back to Excel 2011 until this is fixed.
the sooner the better. we are waiting
What is the progress on this...?
For the love of all that is holy, can you fix the biggest annoyances while your re-porting the editor?
Customize more color options for the editor, allow for custom font/font sizes within the editor, and allow people to specify the limit of the immediate window's scrollback history (don't limit to 1023 characters).
we badly wait for it. we got lots of customers depending on it.
Enable the ability to increase the font. please.