New computer, new Office

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
22,684
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.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,146
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
434
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,146
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
22,684
By create userforms, do you mean at run-time or design time?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,146
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
22,684
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,146
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
22,684
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,146
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
It is, but it has the same issues.
 

Forum statistics

Threads
1,077,721
Messages
5,335,812
Members
399,051
Latest member
WPO

Some videos you may like

This Week's Hot Topics

Top