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 No 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 No comments

66 additional answers

Sort by: Oldest
  1. Jim G 134.1K Reputation points MVP
    2015-10-09T16:11:04+00:00

    Do you know where we could find a list of features (1) currently available in Office 2016 for Windows and (2) previously available in Office for Mac 2011 that aren't (yet) available in Office 2016 for Mac?  Those of us sitting on the bench could then wait until Office 2016 for Mac has achieved parity with its former counterpart before making the "upgrade".

    Cheers

    Microsoft Office is a huge thing. There are tens of thousands of features, large and small. I don't know of an inventory of all Office features. New features are added, existing features are fixed or changed, and features are lost with each new build of Office. These builds come out every few weeks in updates for the Mac and for the PC, so maintaining a list of features would be a gargantuan task.

    There is one person who has devoted his time for the past couple of years to document VBA differences and come up with work-arounds for VBA on the Mac vs the PC. His 2011 site is here:

    http://www.rondebruin.nl/mac.htm

    When you visit Ron's site click the Mac Tips and Articles tabs for lots of helpful information. Also check his Home page and check under What's New to see even more.

    The lack of menu, toolbar, QAT and Ribbon customization is expected to be remediated soon. At least that is what I gather from the hints Microsoft has been making about their plans for Office 2016 on the Mac. If you're planning to customize the Ribbon, I recommend learning about **RibbonX**. That's how I anticipate that User Interface (UI) customization will occur so that it matches Office for Windows. 

    As for feature parity, I am completely disheartened. Office 2016 has been out a couple months now and still every day I learn about yet another feature that is broken or missing. Today I learned that the new Waterfall charts in Excel 2016 for Windows don't even render in Excel on the Mac.

    Microsoft has poured resources into mobile devices at the expense of the desktop and it shows. The mobile apps are wonderful. The desktop app has been neglected and the gap between the Mac and Windows versions of Office has grown to be an enormous chasm. The 2016 VB Editor and Microsoft Query SQL editor are in your face failures. Conforming to Apple's "sandboxing" rules breaks so much stuff it's ridiculous. Microsoft has not given me any confidence they have the will or the ability to bridge the gap.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2015-10-09T16:42:37+00:00

    Wonder now that Corel Know what messing Office is on Mac They could be convinced to bring it back to the Mac Platform.  Next Mac I get I am tempted to get an addition Drive Put Parallels on it, get Windows and Buy the WordPerfect Suite.  I originally started out on WP and thought at the time it was Greatest thing since sliced Bread. 

    Then Mr Gates went on a rampage forcing people to sell out or quit making products, or risk smear campaigns, and other actions to get his way. WordPerfect Corp sold Itself to Corel who put in writing on the Internet they would continue development of the Mac Platform. As soon as ink Dried on paper they killed Mac development work. Later in the news reporting agencies (of the day) for computer news it was disclosed development of Mac version was halted after Microsoft had a chat with Corel. Nobody came out with a Statement saying Corel was forced from Mac Development of WP. But it sure sound that way without the smoking gun.

    Disclaimer: *The above statement is my opinion and my opinion only. While Microsoft still has the best office Suite for Mac. And it still is a Good product (no longer great)*Microsoft still needs some serious competition to spur better development.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2015-12-01T23:51:43+00:00

    lol - Microsoft told you no such thing.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2015-12-01T23:56:14+00:00

    Great story Phil, it makes for a really interesting alternative to reality.

    Got any more?

    Was this answer helpful?

    0 comments No comments