| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
optionbox checkbox
I have 8 option box and 1 checkbox
when I click the check box it displays average totals ( if statement selects which of the 8 options box is clicked and provides average sheet accordingly). however when I untick the checkbox.. its still displays the average. on |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
optionbox checkbox
Presumably because you don't un-display it?
Can you show the code? -- HTH RP (remove nothere from the email address if mailing direct) "flow23" wrote in message ... I have 8 option box and 1 checkbox when I click the check box it displays average totals ( if statement selects which of the 8 options box is clicked and provides average sheet accordingly). however when I untick the checkbox.. its still displays the average. on |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
optionbox checkbox
what is un-diplay?
the code is as follows.. ( very unprofessional) Private Sub CheckBox2_Click() Dim i As String If OptionButton1 = True Then obutt1 Else If OptionButton2 = True Then obutt2 Else If OptionButton3 = True Then obutt3 Else If OptionButton4 = True Then obutt4 Else If OptionButton5 = True Then obutt5 Else If OptionButton6 = True Then obutt6 Else If OptionButton7 = True Then obutt7 Else If OptionButton8 = True Then obutt8 Else If OptionButton9 = True Then obutt9 Else If OptionButton10 = True Then obutt10 End If End If End If End If End If End If End If End If End If End If End Sub "Bob Phillips" wrote: Presumably because you don't un-display it? Can you show the code? -- HTH RP (remove nothere from the email address if mailing direct) "flow23" wrote in message ... I have 8 option box and 1 checkbox when I click the check box it displays average totals ( if statement selects which of the 8 options box is clicked and provides average sheet accordingly). however when I untick the checkbox.. its still displays the average. on |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
optionbox checkbox
Doing something to clear whatever was previously displayed.
And the code is far from complete. -- HTH RP (remove nothere from the email address if mailing direct) "flow23" wrote in message ... what is un-diplay? the code is as follows.. ( very unprofessional) Private Sub CheckBox2_Click() Dim i As String If OptionButton1 = True Then obutt1 Else If OptionButton2 = True Then obutt2 Else If OptionButton3 = True Then obutt3 Else If OptionButton4 = True Then obutt4 Else If OptionButton5 = True Then obutt5 Else If OptionButton6 = True Then obutt6 Else If OptionButton7 = True Then obutt7 Else If OptionButton8 = True Then obutt8 Else If OptionButton9 = True Then obutt9 Else If OptionButton10 = True Then obutt10 End If End If End If End If End If End If End If End If End If End If End Sub "Bob Phillips" wrote: Presumably because you don't un-display it? Can you show the code? -- HTH RP (remove nothere from the email address if mailing direct) "flow23" wrote in message ... I have 8 option box and 1 checkbox when I click the check box it displays average totals ( if statement selects which of the 8 options box is clicked and provides average sheet accordingly). however when I untick the checkbox.. its still displays the average. on |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checkbox | Excel Discussion (Misc queries) | |||
| Help with function to add percentage to cell based on checkbox. | Excel Worksheet Functions | |||
| copy many CHECKBOX | Excel Discussion (Misc queries) | |||
| How do I make a checkbox bigger? | Excel Discussion (Misc queries) | |||
Linear Mode
