PDA

View Full Version : Userform/Checkboxes Formatting



Juicey27
09-09-2010, 05:01 AM
Excel 2007 - VBA - Userform
One Answer per Question : Checkboxes

I have a userform with 8 questions, 3 checkboxes for each question, and a total of 24 checkboxes. For each question the three available checkbox choices are YES, NO, N/A. (Please see attachment.) Is there a way so that when selecting the answer, an individual is only able to select one of the three checkboxes per question? For example: On question one > if I select "YES" as my answer then i want the userform to prevent me from being able to also select either "no" or "n/a" for that same question. This way I can ensure that only one answer is selected/submitted per question. Any suggestions are welcome!!
(Please see attachment.)

mikerickson
09-09-2010, 06:24 AM
It sounds like the UF should use Option Buttons rather than CheckBoxes.
Put the option buttons in a frame to keep them acting as a group.

Juicey27
09-10-2010, 01:42 PM
This works. Thank you so much for your help. Any chance you can tell me how to erase the border around the frames??

Tinbendr
09-10-2010, 03:40 PM
Try this.

mikerickson
09-11-2010, 11:11 AM
This works. Thank you so much for your help. Any chance you can tell me how to erase the border around the frames??
The Property window shows .BorderStyle, .BorderColor, and .Caption as being among the properties of a frame.