How to only allow one box to be checked on a Word form

[PaultheS]

I'm making a form right now with a pretty standard "How did you find our service? 1 (Bad) 2 (Not great) 3 (Satisfactory)...", where the headings are above the questions and then beside each question there are 5 check boxes. Naturally I want to only allow them to select one of the five options for each question.

Is there an easy setting I can use, or am I stuck using VBA, or...?

 

[TonyJollans]

Hi PaultheS,

Instead of Checkboxes, use Option Buttons - and if you have multiple sets of them, give each set a different GroupName. Only one option button with any particular Groupname can be selected at once.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[fumei]

Tony should have mentioned that these are ActiveX Option Buttons. You get access to them with View > Controls.

To set them with a GroupName, right click them and select Properties. There is a GroupName item. Give each Option Button the same name.

Inserting a ActiveX control brings up the Controls toolbar and a floating little toolbar. To end controls inserting, click the little floating toolbar.

Gerry
See my Paintings and Sculpture

 

[PaultheS]

Thanks guys. I did figure out eventually that they were ActiveX controls and it fixed my problem nicely.

 

[fumei]

Excellent.

Gerry
See my Paintings and Sculpture

 

[TonyJollans]

Hi PaultheS,

Glad you're sorted - sorry if I didn't provide the information in the best way - I had UserForms in my mind (and not Word Forms) when I wrote the reply, but Gerry was there keeping a watchful eye so all was well

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[PaultheS]

I have sort of a new problem now... When I Protect my form, everything works fine and I can click the option buttons and so forth. Then, when I close it and re-open it, it seems to be protected and in design view (so I can't click the option buttons, and I also can't unprotect it).

Ideally I'd like it to open protected and not in design view so the form can be used properly... Any advice?

 

[fumei]

This is an unfortunate aspect of security. Because ActiveX controls can DO stuff so much, Word (unless you have Security on Low) opens things in design view, which means the controls do not run automatically.

You maight try putting

ActiveDocument.ToggleFormsDesign

into your ThisDocument.Document_Open event.

Gerry
See my Paintings and Sculpture