In the charts below, Schmucker breaks down feature-by-feature exactly what you get (and don’t get) in each of the different versions of the productivity suite including Office 2016 and 2013 for Windows, Office 2016 and 2011 for Mac,. The full charts (below) show suite-wide differences between the versions such as missing apps, lack of support for Visual Basic and ActiveX, right-to-left language support, accessibility features, AppleScript and much more. Other charts in the study show feature variations for Word, Excel, PowerPoint, and Outlook, with the majority of the features listed unavailable for iPad users and a mixed bag for the other versions.

And Schmucker points out two things regarding the iPad specifically. One positive is support for right-to-left languages, which he notes is something that Mac users have bene asking for but have yet to receive, while a negative for the iPad is lack of multiple selection support in PowerPoint, something Schmucker notes is a pretty basic but crucial function for the app. In the end, he concludes that a mix of the various Office suites is the best approach but admits that his main, go-to version is MacOffice 2011 (apart from using the latest version of Outlook due to enhanced performance): “I worked for the MacOffice team at Microsoft for several years, and at that time I also worked closely with colleagues on the WinOffice teams. Because of this background, I am often able to pick just the right Office app that will make a given task the easiest to do. One task might be particularly well suited to MacWord 2011 because Publishing Layout View— a feature only in that one Word version— will make this task easy. Another task might be suited to WinPPT because of the Animation Painter, which is not in any MacPPT version.

All Windows versions have ActiveX controls; the Mac does not. Use the ‘Forms’ toolbar when coding in Windows if you want to share with Mac users. (This applies only to adding controls to a document; UserForms are cross-platform.) A good starting point for understanding the differences and limitations is the Help in Word X for Mac.

Yet another task might be best suited to WInPPT 2013 because it needs an Office extension not available in other Office suites.” And this is what Schmucker’s setup looks like with various versions of Office installed on Mac and using virtual machines: • MacOffice 2011 is my main productivity suite and is installed on my El Capitan MacBook Pro. MacOutlook 2016 came out long before the entire MacOffice 2016 suite, and because of the vastly improved performance of MacOutlook 2016, I use it as my main email client, instead of MacOutlook 2011. • WinOffice 2013 is installed in a Windows 7 virtual machine (VM) (under Parallels Desktop for Mac Pro Edition) on my MacBook Pro.

• iPad Office is installed on my iPad. As you saw in the tables above, iPad Office is lacking many of the features of WinOffice and MacOffice, so I also have on my iPad which lets me access and run the full featured versions of any Office suite (or any other application) on my computers and use them with natural iPad gestures. (You can download a free trial of Parallels Access for iOS and Android to access your Mac and/or PC at ).w • MacOffice 2016 is installed in an El Capitan VM (under Parallels Desktop for Mac Pro Edition) on my MacBook Pro. • WinOffice 2016 is installed in a Windows 10 VM (under Parallels Desktop for Mac Pro Edition) on my MacBook Pro.

Click the charts below to view them in full size.

I have a worksheet it has a list of customers (it changes but it is a named range and every time the list changes, the named range reference also changes). Currently I have a macro which requires the user to input the customers name. Based on the customer name input, my user gets a list of all transactions with that customer. My problem is that the users sometimes make mistakes in entering customer name which cause 'NIL' response and they come to me complaining.

I would like to give them a List of Customers (from the named range) and ask them to select from the list and use that as input for my macro. I have very basic knowledge of VBA and have never used ListBox or UserForms. Can someone suggest how to do it so that it works on Excel for Mac and Windows? Many many thanks. Code: lCount = ListBox1.Value MsgBox lCount & ' The Selected one', vbOKOnly BeforeExit: Set rRange = Nothing Unload Me Exit Sub ErrorHandle: MsgBox Err.Description Resume BeforeExitIn this case I get error 'Object Required'.