Hi
I am new to word vba but wanted a little help.



I have a user form current with several forms of input including two label check boxes.

I would like if possible a vba that shows and error message if either both or neither of the boxes have been selected.

Any help would be appriciated

Thanks

The usual way on handling this kind of thing on a userform is to use grouped radio buttons, thus obviating the risk that none, or more than one, can be active. Is there a reason you can't do this?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi, it could be an option to use a radio button. I have been requested to set a form up based on an old set up but want to put rules in place to make sure it won't let you do certain things, I.e check more than one box for same option and save without having completed certain parts of forms. This is all very new to me I'm more of a excel vba person!

Excel userforms and Word userforms are the same regarding the use of checkboxes & radiobuttons.

Please clarify that this is a userform we're discussing and not a document being used as a form.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Sorry, at the moment I believe that it is a document that is being set up as a form

OK, in that case you may not have access to option buttons. What kinds of controls are you proposing to use (e.g. content controls, formfields, ActiveX controls)?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

At the moment I believe I am using the label and active X buttons in the developer tab

OK, in that case you have access to the ActiveX option buttons, which can be grouped as previously discussed. No VBA required.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]