VBA Checkbox Word does not work

Question

On a Windows pc I made a word document where users can make an automatically generated quotation for customers. The user has to select the subjects (with checkboxes) he wants to be in the quotation, press on a button and the document start generating a new word document (quote) which includes all the selected subjects. 

Recently I bought a Mac with Office 2016 and the document is not working anymore. I can not press the button anymore, can not select checkboxes. In total, the Macro does not work at all anymore. Does someone know what the problem is and how I can fix it?

Answer 1

For best compatibility with all versions of Word, use the Legacy Form Field checkbox (Word 2010 menu location shown below), then protect the document for forms:

You'll also get excellent compatibility if you put all your controls on a user form, then use VBA to display that. Here's a 3-part Introduction to User Forms to get you started.

If you're using Content Controls (the ones that are on the main Ribbon, not the in dropdown shown above), those will work with Word 2010, 2013 and 2016 for Windows and 2016 for Mac if you are fully updated (it's a new feature added in the last month, check Word>About Word, you should be on 15.23.2).

As Phillip noted, ActiveX controls from the bottom part of the dropdown will not work on a Mac at all.

Answer 2

First off I am by no means an expert on VBA and Macro's in fact I do not use them. All I know (which is tiny) I have learned on this forum.  I do know that there are three types of VBA to write Macros. The PC Version is capable of using all three.

One use's active X-Controls.

I know for a fact that will never change unless there is a policy shift at Apple. Back in the late 90's Netscape then the top dog on the Internet browser market, came out with an Active-X plug-in. Apple began getting reports about odd things happening after using Netscape Navigator after the install of the ActiveX Plug-in. Apple discovered that the code used my Microsoft to create Active-X had no safety controls and could not be made safe. So they took the almost unheard of action in those days, of banning Active-X and all OS systems after that were written not to recognize Active-X.

There is one other method that simply wasn't made available to Mac users by Microsoft. Finally the third method I believe is called Classic can be used by Mac's. You have to look the actual type I am referring to and rewrite your Macro in that form which will work on both PC and Mac. 

I am sure one of the MVP's will be along to tell you the version of VBA you can use. 

_________

Disclaimer:

The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Community Moderator.