Hey, CoolBlue,

Even more complex and more possibilities …

As you seem to be very experienced with (ActiveX) controls and VBA, you might be able to answer my question:
I’m working on an evaluation sheet with 238 check boxes an 136 option buttons. My original intention was to use Word, as it’s more a formatting than a calculation effort.
For check boxes I can use FormControls in Word, but–other than Excel–Word does not offer option buttons as FormControls. So I need 136 ActiveX option buttons. I don’t know exactly up to how many ActiveX Controls Word can manage without problems, but 136 of them make Word take more than 10 sec. to open. 10 seconds is (much) more than any of 'my users' would except. Consequently we decided to switch to Excel. But Excel is not designed for formatting longer text, so it’s a PITA.

Do you have any idea, how I could speed up the Word document? If not, I will stick to Excel, hoping the text will not change frequently.

Sorry for continuing this thread with a somehow OT question in Excel programming forum … no need to move it to the Word forum, the topic already exists (https://www.msofficeforums.com/word-...o-buttons.html).

NP