
(aka PushButtons) and ComboBoxes (aka ListBoxes) not being able to ‘takeįocus’ should be aware that they can in Windows, and also that a UserForm

Mac programmers who are used to things like CommandButtons You use conditional compilation, and have some way to implement the same To the Mac, so if you’re developing on a Mac avoid AppleScript, unless Most of the differences are only potential problems whenĭeveloping in a Windows version of Word, but there are a few that work in Of course, copy-and-paste the code into a Word document and save it as textįile with the ‘.bas’ extension, and it is possible, using additionalĬode, to export and import forms and modules, but these workarounds are notĪs convenient as using menu commands, as can be done in Windows. The ‘Insert’ menu to add its contents to a module, but you cannotĭirectly export such files yourself to share with Windows users. bas file from a Windows machine, you can use ‘File…’ on To directly export and import items in the Visual Basic Editor. While not a design issue, another missing feature on the Mac is the ability

Hard-coding file paths will surely fail cross-platform. Has to say about paths and the Application.PathSeparator function If you need to access files, pay special attention to what the second topic Strategies for Developing Cross-Platform Solutions.Differences Between Word VBA for Windows and Word VBA for the Macintosh.Two Help topics in particular give a fairly good (This applies only to adding controls to a document UserFormsĪ good starting point for understanding the differences and limitations is ‘Forms’ toolbar when coding in Windows if you want to share with This lack is not usually a problem unless you useĪn Excel worksheet as a data source, but you should be aware of it.Īll Windows versions have ActiveX controls the Mac does not. Least Word 97, but has never been implemented on the Mac, is the RowSource One item that is available in all Windows versions of Word back through at Both of theseĪre available on Windows (in Word after Word 97), but not on the Mac. These include the Split() Function, and non-modal windows. Means that there are some commands and functions that are available in WordĢ000, Word 2002 and Word XP that just are not available on the Mac. VBA in Word 97 for Windows is also based on VB5,īut later versions of Word for Windows use VB6 as the basis for VBA.

Visual Basic for Applications (VBA) in all versions of Word for Mac is based Wish to create cross-platform solutions there are some significant differences Generally speaking the differences between Word for Mac and Word for WindowsĪre minimal…at least from the user’s point of view. Article contributed by George Clark A Developer’s Perspective
