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]
Sean Franklin commented
7 months later - still nothing? No way to even edit a .xlam function, other than copy the whole module - paste into a new worksheet - make changes - save as .xlam - quit Excel - overwrite - restart Excel. Efficient? Not terribly!
Macros worked in 2011 excel does not work in 2016 without substantial modification. Like creating PDF with ExportAsFixedFormat
mySheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=myFolderName & myFileName, _
Quality:=xlQualityStandard, IncludeDocProperties:=True, _
Working on Porting?! Why did you bother releasing visual Basic for Excel in the first place? None of the macro's I wrote on my windows machine work on this new version without major changes. And I cant be bothered to make changes to stuff that worked yesterday.
This is BS.The old Bill Gates would had executed the entire development team for this rubbish release.
I'm so glad I still have VMware on my Mac
Andrew Duncan commented
Dan, is there any time line for the introduction of the NEW improved VBE?
This Excel 2016 it's to bad to be true. I took years to have "perfect" procedures creating folders and saving pdf file, and now nothing works on 2016.
What a disillusion. On a time that everything gets better I really don't this "desevolution" on the main functions that makes Excel a lot better than the others.
But it seems that this was in the past, not anymore. It's a shame.
I have just discovered that Mac Excel 2016 doesn't allow macro's to be opened and viewed. I would not have purchased if i had known this. I found this comment from Oct 2015 that says you are working on it - can you tell me the status of this now? Thanks heaps
C. P. Rautenbach commented
In the meanwhile: How do I get a copy of the actually working 2011 version without having to pay again?
The 2016 excel is worthless for me as it is.
Thanks in advance.
Iain MacIntyre commented
It is beyond belief that the MS post is headlined "Good News"...
So many things that work on Excel 2011 MAC and also work on current Excel for PC just do not work in Excel 2016 for MAC. One tiny example that comes to mind is modal userforms. And like others on this forum, I have lost count of the number of dev hours spent trying to debug a project in the dark.
Constant updates to Excel 2016 are not helping. MS should be issuing refunds now with free copies of a fully function Excel for Mac when the developers finally get around to tackling this 'big project'. What a joke.
Arnaud Bonneville commented
I am very disappointed by the VBA module in Excel 2016. It simply doesn't work. I wonder why Microsoft has proposed such a degraded version of this product. Excel is the main reason why I did not select other products, because of the ability to automate work through macros. This regression is simply unacceptable.
The clients using my program want to know what the time line on "take a while" might be?
Andrew Duncan commented
Is Excel 2016 for MAC code so different from Excel 2016 for Windows that you have to go back to Excel 2011? Why can't the VBA editor from the Windows version not be ported into the Mac version? Office 2016 Mac is a poor cousin of the new Office suite.
Tarak Patel commented
It's highly recommended to have full working VBE. The current VBE is too much basic. The debugging features are much limited. Not so good.
martin meier commented
Is there a search function in the editor? I can't find it. How can I work with hundreds of lines of code without a search function?
John Doe commented
why can't users set VBA Project properties for security? this is so retarded!
I would not have purchased 2016 excel if I knew this was done, how stupid to do this. I am completely shocked and disgusted with this decision. The VBA editor is worthless to me. Now I have to purchase a back edition of excel 2011 or use my wife's windows pc. I would really like a refund as I am a developer and paid good money for this worthless product.
K M Khan commented
i only bought the office for mac as I was under the impression it would function similar to the windows version to allow me create customs forms and functions etc. What is the point of paying so much for it if these capabilities are not available
Rich Ransom commented
I too need a fully functional VBE, like so many who have already made a comment (and many more who haven't commented!). Please make it sooner than later - Thank you!
Ted Barrera commented
Dan, I've got macros that run perfectly on 2011 that eternal beachball on me on 2016 (basically freezing the app indefinitely). Is anything being done to address this issue? I assume I'm not the only one experiencing this issue, or you wouldn't be asking if 2011 macros have have freezing up on 2016.
What happened to intellisense in VBA 2016? When are we going to have it back?
Giorgio Tassi commented
This is good news. Pls advise when this upgrade is completed, and I will buy the new Excel 2016 for Mac in the Office Suite