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. 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
  2. Anonymous
    2015-12-01T23:51:43+00:00

    lol - Microsoft told you no such thing.

    Was this answer helpful?

    0 comments
  3. 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
  4. Anonymous
    2015-10-09T11:06:08+00:00

    I have been sooooooo lucky with Microsoft products. I bought a PC running Vista, then another running Windows 8 and because of all this hassle switched to a Mac only to buy Office for Mac 2016!

    At least I have been able to edit my macros to run on both PC and Mac with the help of trial and error. Apart from the help I have had from internet forums this method is just about the same as when we were editing BASIC in the 70s. So much for progress.

    Was this answer helpful?

    0 comments