Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkboxes with the same Group Name not Responding
I have 4 Checkboxes in a UserForm. I have given all 4 Checkboxes the
GroupName = "Shipping" in the Properties Window in the VBA Editor. We I Show the UserForm and click on one Checkbox the others do not turn off, why? Thanks in Advance, Ryan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkboxes with the same Group Name not Responding
That's the way checkboxes work.
Maybe you meant to use OptionButtons -- they'll only allow one option to be chosen in each group. RyanH wrote: I have 4 Checkboxes in a UserForm. I have given all 4 Checkboxes the GroupName = "Shipping" in the Properties Window in the VBA Editor. We I Show the UserForm and click on one Checkbox the others do not turn off, why? Thanks in Advance, Ryan -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkboxes with the same Group Name not Responding
You can make a check box look like an option button by deselecting the other
boxes when one comes true Private Sub CheckBox2_Click() if checkbox2 = true then checkbox1 = false checkbox 3 = false end if End Sub "Dave Peterson" wrote: That's the way checkboxes work. Maybe you meant to use OptionButtons -- they'll only allow one option to be chosen in each group. RyanH wrote: I have 4 Checkboxes in a UserForm. I have given all 4 Checkboxes the GroupName = "Shipping" in the Properties Window in the VBA Editor. We I Show the UserForm and click on one Checkbox the others do not turn off, why? Thanks in Advance, Ryan -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkboxes with the same Group Name not Responding
I could use option buttons, but I would prefer the look of the checkboxes.
The help section says the GroupName Property supports option buttons, but why does the GroupName property show up in the Properties window of the VBE? Am I wrong about the possiblity of the checkboxes acting like option buttons? Ryan "Joel" wrote: You can make a check box look like an option button by deselecting the other boxes when one comes true Private Sub CheckBox2_Click() if checkbox2 = true then checkbox1 = false checkbox 3 = false end if End Sub "Dave Peterson" wrote: That's the way checkboxes work. Maybe you meant to use OptionButtons -- they'll only allow one option to be chosen in each group. RyanH wrote: I have 4 Checkboxes in a UserForm. I have given all 4 Checkboxes the GroupName = "Shipping" in the Properties Window in the VBA Editor. We I Show the UserForm and click on one Checkbox the others do not turn off, why? Thanks in Advance, Ryan -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkboxes with the same Group Name not Responding
Groupname doesn't make check boxes mutually exclusive. It just creates a
common group if any of the boxes are selected. "RyanH" wrote: I could use option buttons, but I would prefer the look of the checkboxes. The help section says the GroupName Property supports option buttons, but why does the GroupName property show up in the Properties window of the VBE? Am I wrong about the possiblity of the checkboxes acting like option buttons? Ryan "Joel" wrote: You can make a check box look like an option button by deselecting the other boxes when one comes true Private Sub CheckBox2_Click() if checkbox2 = true then checkbox1 = false checkbox 3 = false end if End Sub "Dave Peterson" wrote: That's the way checkboxes work. Maybe you meant to use OptionButtons -- they'll only allow one option to be chosen in each group. RyanH wrote: I have 4 Checkboxes in a UserForm. I have given all 4 Checkboxes the GroupName = "Shipping" in the Properties Window in the VBA Editor. We I Show the UserForm and click on one Checkbox the others do not turn off, why? Thanks in Advance, Ryan -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkboxes with the same Group Name not Responding
Just to add to what Joel wrote...
It's not always what the developer thinks looks nice. As a user, I would expect checkboxes to be independent of each other -- and grouped optionbuttons to be mutually exclusive. If the developer doesn't follow those rules, it can be more confusing to the user. RyanH wrote: I could use option buttons, but I would prefer the look of the checkboxes. The help section says the GroupName Property supports option buttons, but why does the GroupName property show up in the Properties window of the VBE? Am I wrong about the possiblity of the checkboxes acting like option buttons? Ryan "Joel" wrote: You can make a check box look like an option button by deselecting the other boxes when one comes true Private Sub CheckBox2_Click() if checkbox2 = true then checkbox1 = false checkbox 3 = false end if End Sub "Dave Peterson" wrote: That's the way checkboxes work. Maybe you meant to use OptionButtons -- they'll only allow one option to be chosen in each group. RyanH wrote: I have 4 Checkboxes in a UserForm. I have given all 4 Checkboxes the GroupName = "Shipping" in the Properties Window in the VBA Editor. We I Show the UserForm and click on one Checkbox the others do not turn off, why? Thanks in Advance, Ryan -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkboxes with the same Group Name not Responding
Adding instruction on the userfrom to "Select One" will eliminate the
confussion "Dave Peterson" wrote: Just to add to what Joel wrote... It's not always what the developer thinks looks nice. As a user, I would expect checkboxes to be independent of each other -- and grouped optionbuttons to be mutually exclusive. If the developer doesn't follow those rules, it can be more confusing to the user. RyanH wrote: I could use option buttons, but I would prefer the look of the checkboxes. The help section says the GroupName Property supports option buttons, but why does the GroupName property show up in the Properties window of the VBE? Am I wrong about the possiblity of the checkboxes acting like option buttons? Ryan "Joel" wrote: You can make a check box look like an option button by deselecting the other boxes when one comes true Private Sub CheckBox2_Click() if checkbox2 = true then checkbox1 = false checkbox 3 = false end if End Sub "Dave Peterson" wrote: That's the way checkboxes work. Maybe you meant to use OptionButtons -- they'll only allow one option to be chosen in each group. RyanH wrote: I have 4 Checkboxes in a UserForm. I have given all 4 Checkboxes the GroupName = "Shipping" in the Properties Window in the VBA Editor. We I Show the UserForm and click on one Checkbox the others do not turn off, why? Thanks in Advance, Ryan -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkboxes with the same Group Name not Responding
I wouldn't want to clutter my userforms with stuff like that.
I wouldn't want to use Tools|Options and see instructions on each tab explaining how checkboxes should be used. I wouldn't expect most users to read these kinds of instructions, either. Joel wrote: Adding instruction on the userfrom to "Select One" will eliminate the confussion "Dave Peterson" wrote: Just to add to what Joel wrote... It's not always what the developer thinks looks nice. As a user, I would expect checkboxes to be independent of each other -- and grouped optionbuttons to be mutually exclusive. If the developer doesn't follow those rules, it can be more confusing to the user. RyanH wrote: I could use option buttons, but I would prefer the look of the checkboxes. The help section says the GroupName Property supports option buttons, but why does the GroupName property show up in the Properties window of the VBE? Am I wrong about the possiblity of the checkboxes acting like option buttons? Ryan "Joel" wrote: You can make a check box look like an option button by deselecting the other boxes when one comes true Private Sub CheckBox2_Click() if checkbox2 = true then checkbox1 = false checkbox 3 = false end if End Sub "Dave Peterson" wrote: That's the way checkboxes work. Maybe you meant to use OptionButtons -- they'll only allow one option to be chosen in each group. RyanH wrote: I have 4 Checkboxes in a UserForm. I have given all 4 Checkboxes the GroupName = "Shipping" in the Properties Window in the VBA Editor. We I Show the UserForm and click on one Checkbox the others do not turn off, why? Thanks in Advance, Ryan -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkboxes with the same Group Name not Responding
I would agree with that. I switched to option buttons and everything is great!
Thanks "Dave Peterson" wrote: I wouldn't want to clutter my userforms with stuff like that. I wouldn't want to use Tools|Options and see instructions on each tab explaining how checkboxes should be used. I wouldn't expect most users to read these kinds of instructions, either. Joel wrote: Adding instruction on the userfrom to "Select One" will eliminate the confussion "Dave Peterson" wrote: Just to add to what Joel wrote... It's not always what the developer thinks looks nice. As a user, I would expect checkboxes to be independent of each other -- and grouped optionbuttons to be mutually exclusive. If the developer doesn't follow those rules, it can be more confusing to the user. RyanH wrote: I could use option buttons, but I would prefer the look of the checkboxes. The help section says the GroupName Property supports option buttons, but why does the GroupName property show up in the Properties window of the VBE? Am I wrong about the possiblity of the checkboxes acting like option buttons? Ryan "Joel" wrote: You can make a check box look like an option button by deselecting the other boxes when one comes true Private Sub CheckBox2_Click() if checkbox2 = true then checkbox1 = false checkbox 3 = false end if End Sub "Dave Peterson" wrote: That's the way checkboxes work. Maybe you meant to use OptionButtons -- they'll only allow one option to be chosen in each group. RyanH wrote: I have 4 Checkboxes in a UserForm. I have given all 4 Checkboxes the GroupName = "Shipping" in the Properties Window in the VBA Editor. We I Show the UserForm and click on one Checkbox the others do not turn off, why? Thanks in Advance, Ryan -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkboxes with the same Group Name not Responding
And it makes your life as a developer much easier!
RyanH wrote: I would agree with that. I switched to option buttons and everything is great! Thanks "Dave Peterson" wrote: I wouldn't want to clutter my userforms with stuff like that. I wouldn't want to use Tools|Options and see instructions on each tab explaining how checkboxes should be used. I wouldn't expect most users to read these kinds of instructions, either. Joel wrote: Adding instruction on the userfrom to "Select One" will eliminate the confussion "Dave Peterson" wrote: Just to add to what Joel wrote... It's not always what the developer thinks looks nice. As a user, I would expect checkboxes to be independent of each other -- and grouped optionbuttons to be mutually exclusive. If the developer doesn't follow those rules, it can be more confusing to the user. RyanH wrote: I could use option buttons, but I would prefer the look of the checkboxes. The help section says the GroupName Property supports option buttons, but why does the GroupName property show up in the Properties window of the VBE? Am I wrong about the possiblity of the checkboxes acting like option buttons? Ryan "Joel" wrote: You can make a check box look like an option button by deselecting the other boxes when one comes true Private Sub CheckBox2_Click() if checkbox2 = true then checkbox1 = false checkbox 3 = false end if End Sub "Dave Peterson" wrote: That's the way checkboxes work. Maybe you meant to use OptionButtons -- they'll only allow one option to be chosen in each group. RyanH wrote: I have 4 Checkboxes in a UserForm. I have given all 4 Checkboxes the GroupName = "Shipping" in the Properties Window in the VBA Editor. We I Show the UserForm and click on one Checkbox the others do not turn off, why? Thanks in Advance, Ryan -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range.Group Method - group rows, not columns | Excel Programming | |||
Group Checkboxes to only allow on "checked" box | Excel Worksheet Functions | |||
Looping through a group of checkboxes | Excel Programming | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
How to select checkBoxes as a group in | Excel Programming |