Limit users to checking one box with keystroke X in form?

H

hinesgg

I've created a form with checkboxes. I've also created a macro that allows users to click on only one checkbox at a time. In testing my form, I've learned that the macro works if the mouse is used, but if an X is entered into the checkbox using the keyboard, the macro does not work and users can enter an X into any box they want. What can I add to my macro to exclude use of the keyboard

I'd appreciate any advice you can give

Here's my macro
Sub CheckBox23Yes(
If ActiveDocument.FormFields("Check23").CheckBox.Value = True The
ActiveDocument.FormFields("Check24").Result = Fals
ActiveDocument.FormFields("Check25").Result = Fals
Els
ActiveDocument.FormFields("Check23").Result = "

End I
 
D

Doug Robbins - Word MVP

Use the method in the article “Making groups of Check Box Form Fields
mutually exclusive (so
that they behave like radio buttons “ at:

http://word.mvps.org/FAQs/TblsFldsFms/ExclusiveFmFldChbxs.htm


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
 
P

Peter Hewett

Hi hinesgg

See my answer in microsoft.public.word.docmanagement.

Please don't multi-post messages, if you believe a message is relevant to more
than one News Group then cross post the message instead. That way the answers
will be seen in all NG's.

HTH + Cheers - Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top