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
    2017-06-30T23:18:49+00:00

    Hello DullingWine :)

    I have just updated to Office 2016 for Mac... yeark for the VBA Editor!

    Are you aware of any improvement since you posted your comment on July 12, 2015?

    It's unbelievable that Microsoft is letting us down so badly.

    Best Regards,

    Pierre

    Was this answer helpful?

    0 comments
  2. Jim G 134.1K Reputation points MVP
    2016-10-27T15:13:36+00:00

    Me, too. I subscribe to the Fast Insider builds. Every time a new build comes the first thing I do is open the VB Editor to see if the new one has arrived.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-10-26T17:20:12+00:00

    Not sure I ought to add this to the thread but perhaps some changes in VBA have started.

    Don’t know whether it was the recent update to the 2016 Office suite 15.27 (161010) or the updated Mac OS Sierra but one of my macros stopped working. However I found the problem and solution.

    Before the changes Workbooks.Open filename did not automatically make this file the active workbook and it needed Windows(filename).Activate as well. This is now not required which means that it is the same as the PC code.

    Also and more importantly the filename had to have the extension .xls removed. Now it will accept the filename with extension just like the PC code.

    Unfortunately I still have to test for on which platform the macro is running as the file separator is either  “\” for PC or “/” for Mac

    Glad to hear there is an editor on the way. I need it.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-10-24T03:43:36+00:00

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

    Was this answer helpful?

    0 comments