Visual Basic Support in Mac 2016

Anonymous
2015-07-10T19:25:34+00:00

Hi

Am I missing something? I've been periodically using the Excel 2016 for Mac updates but quickly abandoned them because my sheets rely so heavily on VBA and support for that seemed to be missing. 

I've updatd to the production version today (15.2)...and it still seems to be the case? The Visual Basic editor is..ahem...extremely basic with no menus, right click functions or anything. No ability to insert new modules either. Shortcuts don't work (breakpoint, run etc). 

What's going on? Is this it? Please tell me there's some security setting i need to switch or something...please tell me there's basically no way to create macros enabled spreadsheets in Office for Mac 2016?

Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2017-11-22T18:12:09+00:00

Hi Roberto,

You're not missing anything. UserForm support is being built right now and should be available in a few weeks. I don't expect userform support to arrive during the holidays, but I hope we have it before spring.

Thanks Gordon for the answer. I will wait after the holidays the microsoft present for christmas. 

I take this opportunty to wish to everyone a my particolary Merry Christmas. 

Roberto

Was this answer helpful?

10+ people found this answer helpful.
0 comments

66 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134.1K Reputation points MVP
    2015-07-12T16:17:13+00:00

    What's going on is that Microsoft cut the Visual Basic Editor from Office for Mac down to practically nothing at all, as you have noticed. The Microsoft expectation now is that you will use Office 2011 for Mac or Office 2013 or 2016 for Windows as your development platform and use that sorry excuse you see in Office 2016 as a tool to tweak your code and if you're lucky get it to actually run in Office 2016 for Mac desktop.

    Microsoft does not have any plans that I am aware of to provide a Visual Basic Editor for Office for Mac desktop equivalent to the Windows version of Office, or even previous versions of Office for Mac.

    Note: Microsoft has changed since I originally posted this answer. They have now said they will bring a full VB Editor to Office for Mac. No ETA was announced, which means probably a very long wait.

    Was this answer helpful?

    100+ people found this answer helpful.
    0 comments
  2. Anonymous
    2016-10-24T14:46:15+00:00

    Source?  This will be the determining factor in purchasing Office for Mac

    Its listed as an in-progress item on Microsoft Uservoice.  No indication of a completion date though.

    https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/9098431-bring-back-a-fully-functional-vbe-visual-basic-ed

    Was this answer helpful?

    30+ people found this answer helpful.
    0 comments
  3. Anonymous
    2015-09-25T18:19:50+00:00

    I've just spent £119 so that I can port all of my Excel spreadsheets onto the Mac rather than use the Office 2000 on my PC because Microsoft told me they were updating the software to be the same as PC software. Now you tell me that you are not going to give me the tools to alter the macros!

    I'M ANGRY. I WANT MY MONEY BACK!

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  4. Anonymous
    2015-07-10T19:41:13+00:00

    Despite Yesterday being Official Release of 2016 is still very much a work in Progress. and Components will be included as the are finalized and there may be a period of bug fixes. But with the new model system they are using there are going to be glitches. How once 2016 is perfected though have many of the same controls as the PC version Gone are the days of using 30-40 year old binary code that has been patched so many times that the patches were held together with patches.

    2016 is now using apple system code top to bottom. 

    If your favorite thing isn't working Click on the smiley face button on the Ribbon and click on What can be done better and let them know. 

    _________

    Disclaimer:

    The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone, and do not reflect upon my position as a Community Moderator.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments