New computer, new Office

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,280
Hi folks, I bought myself a new Mac Book. My old Office 2011 is out of installs and it looks like Office 2019 is where I'm going. But I do have a couple of questions. Does anyone who has experience with 2019 know if:
1) does it support VBA (in memory of 2008 :) )
2) is the MacScript command supported?

Any reason that I shouldn't get it?

Thanks for your time.
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,802
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
It does support VBA, but the VBE is a dog's dinner. Among other things, you can't create userforms.
 

Paul Ked

Active Member
Joined
Jun 4, 2015
Messages
442
If you use Power Query, forget what you have learned... it's not on Mac unless you are on the Office Insiders team.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,802
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
But coming from 2011 that won't really be a change. ;)
 

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,280
By create userforms, do you mean at run-time or design time?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,802
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Design time. There's no support for it. I'd add "yet" but it's been a loooong time coming with no change.
 

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,280
Grrrr. I hope that it will support existing userforms. Other wise .... I got a problem.


Thanks for all the info.
 
Last edited:

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,802
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Yes, existing userforms are fine, you just can't add new ones. There are also a few other quirks, like you can't use the dropdowns in the code window to create worksheet event declarations. It's a definite step backwards from 2011 as far as the VBE is concerned.
 

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,280
I've seen online third parties offering 2016 and even 2011 for download. Is 2016 for Mac a thing? I like the windows 2016 I have at work.
 
Last edited:

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,802
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
It is, but it has the same issues.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,786
Messages
5,446,492
Members
405,404
Latest member
clead

This Week's Hot Topics

Top