I have a worksheet with a series of questions with 3 check boxes (Y, N. or N/A). Workbook users are selecting more than one checkbox per line. I want to modify so that only one may be selected per line. So if they check Y, and then N, the Y is automatically unchecked.
You should use option buttons instead of checkboxes. This behavior is built-in with option buttons in the same group. Otherwise you have to write a bunch of code to make checkboxes act like that.
I can be more specific if you attach your file.
To post a file:
- Under the text box where you type your reply click the Go Advanced button.
- In the next screen look above the reply box and click the "paper clip" icon. You will get a pop-up screen.
- In the pop-up, click Add then Select to select a file from your local drive
- Click the Upload button to upload the file
- Click Done to attach it.
It will be displayed as an attachment underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.
Hi BBane,
You probably want to trade in your Check Boxes for Radio Buttons. Each Y, N, N/A set should have the same GroupName (Group name of your choice) as selected from the Properties Window. You can access the Properties Window by Right Clicking on a control. For what you want to do 'Control Toolbox' (Active X) Radio buttons may be a little easier to work with than 'Forms' Radio buttons.
Lewis
Here is the file I am working with that has the check boxes. Based on replies, it appears that the check box option was not the best.
See if this helps. I have code to create the buttons so minor changes can be made fairly easily.
This is great. Can I attach multiple copies into a workbook and hold the code to maintain functionality across all worksheets?
Not entirely sure what you mean. You can certainly copy that existing sheet. I'm not sure what you mean by "hold the code". I don't know what "functionality across all worksheets" means, since there is no functionality that references or is referenced by other worksheets. Maybe I could answer better if you describe the scenario you have in mind--how will it be used?
6StringJazzer, I found my mistake in attempting to copy the existing sheet into a multi-sheet workbook. I certainly appreciate all your help with this document. I am sorry you had to deal with such an excel-challenged individual. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks