Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Self canceling checkboxes
Is there anyway to set the checkboxes to self cancel? I have a list setup
and i would like to only select one of the two items with a checkmark, both checkmarks on the same row cannot be checked... or is there some easier way to do this? I would also like to be able to print this out as well and have it completed by hand, hence the check box. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Self canceling checkboxes
It sounds like OptionButtons would be a much better fit. Only one of a group
can be selected. If you use optionbuttons from the Forms toolbar, put a groupbox (also on that same toolbar) around the optionbuttons. And then rightclick on an optionbutton on that group, choose Format Control|control tab. Then assign the linked cell. If you use optionbuttons from the control toolbox toolbar, rightclick on each of the members of the group, choose properties, and give that group a unique groupname. You can assign the Linkedcell on that properties window. ===== If you're creating a survey form, you may want to look at Debra Dalgleish's site: http://contextures.com/xlForm01.html Glenn wrote: Is there anyway to set the checkboxes to self cancel? I have a list setup and i would like to only select one of the two items with a checkmark, both checkmarks on the same row cannot be checked... or is there some easier way to do this? I would also like to be able to print this out as well and have it completed by hand, hence the check box. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Self canceling checkboxes
hi
a check box cannot be set to "cancel" itself. but checkboxes can be set to cancel other checkboxes. example.....3 checkboxes.(activeX, not form) code in checkbox1............... Private Sub CheckBox1_Click() If CheckBox1 = True Then CheckBox2 = False CheckBox3 = False End If End Sub code in checkbox 2............... Private Sub CheckBox2_Click() If CheckBox2 = True Then CheckBox1 = False CheckBox3 = False End If End Sub code in checkbox3................ Private Sub CheckBox3_Click() If CheckBox3 = True Then CheckBox2 = False CheckBox1 = False End If End Sub as you can see, when setting any checkbox to true, code in each automaticly sets all other checkboxes to false. simple, huh. but depending on how may check boxes you have, this technique can get lengthy and wordy. you mentioned 2. i supplied code for 3. dave's suggestion has some strong merrit but personally i have never had much use for optilons boxes. that may be due to my experiences and what i have been required to do over the years. and then again i guess we are all allowed at least one stupid opinion. some people have more. really. my point is that dave did not address the question, only diverted attention. i am attempted to answer the question while admitting that there is more than one way to handle this situation. "best" is sometimes a matter of situation and opinion. your situation, your call. regards FSt1 "Glenn" wrote: Is there anyway to set the checkboxes to self cancel? I have a list setup and i would like to only select one of the two items with a checkmark, both checkmarks on the same row cannot be checked... or is there some easier way to do this? I would also like to be able to print this out as well and have it completed by hand, hence the check box. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Self canceling checkboxes
In using the method described by FSt1 is there away for the check mark to
diplay a number or true false data with it? -- Karissa "FSt1" wrote: hi a check box cannot be set to "cancel" itself. but checkboxes can be set to cancel other checkboxes. example.....3 checkboxes.(activeX, not form) code in checkbox1............... Private Sub CheckBox1_Click() If CheckBox1 = True Then CheckBox2 = False CheckBox3 = False End If End Sub code in checkbox 2............... Private Sub CheckBox2_Click() If CheckBox2 = True Then CheckBox1 = False CheckBox3 = False End If End Sub code in checkbox3................ Private Sub CheckBox3_Click() If CheckBox3 = True Then CheckBox2 = False CheckBox1 = False End If End Sub as you can see, when setting any checkbox to true, code in each automaticly sets all other checkboxes to false. simple, huh. but depending on how may check boxes you have, this technique can get lengthy and wordy. you mentioned 2. i supplied code for 3. dave's suggestion has some strong merrit but personally i have never had much use for optilons boxes. that may be due to my experiences and what i have been required to do over the years. and then again i guess we are all allowed at least one stupid opinion. some people have more. really. my point is that dave did not address the question, only diverted attention. i am attempted to answer the question while admitting that there is more than one way to handle this situation. "best" is sometimes a matter of situation and opinion. your situation, your call. regards FSt1 "Glenn" wrote: Is there anyway to set the checkboxes to self cancel? I have a list setup and i would like to only select one of the two items with a checkmark, both checkmarks on the same row cannot be checked... or is there some easier way to do this? I would also like to be able to print this out as well and have it completed by hand, hence the check box. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
canceling of automatic predicative writing | Excel Discussion (Misc queries) | |||
how to select fewer cells without canceling original selection | Excel Discussion (Misc queries) | |||
canceling auto date update | New Users to Excel | |||
canceling the formula aut-update feature with Arrays | Excel Discussion (Misc queries) | |||
Checkboxes | Excel Discussion (Misc queries) |