Button help

Can i set up a radio button (the circle selection thing i think), that when
selected would then show certain cells in a worksheet or if it's not selected
it doesn't show the cells?

hi
not cells....rows or columns. and you would be much better of using a check
box instead of an option button(radio). options button work better as a group
and not alone. a check box works much better if it's just the only one but
can work as a group.
what rows/columns do you want to show/hide?

regards
FSt1

"James" wrote:

Can i set up a radio button (the circle selection thing i think), that when
selected would then show certain cells in a worksheet or if it's not selected
it doesn't show the cells?

It would be good if i could hide rows 20-25 with a check box if that's
possible.

"FSt1" wrote:

hi
not cells....rows or columns. and you would be much better of using a check
box instead of an option button(radio). options button work better as a group
and not alone. a check box works much better if it's just the only one but
can work as a group.
what rows/columns do you want to show/hide?

regards
FSt1

"James" wrote:

Can i set up a radio button (the circle selection thing i think), that when
selected would then show certain cells in a worksheet or if it's not selected
it doesn't show the cells?

hi
very possible.
from the control toolbox(not the forms), select the checkbox and drag it to
where ever you want it. size it. you can resize the check box itself only the
lable that comes with it.
right click the checkbox, select view code. paste this code into it.
Private Sub CheckBox1_Click() 'this should default in
If CheckBox1.Value = True Then
Rows("20:25").Hidden = True
Else
Rows("20:25").Hidden = False
End If
End Sub 'this should default it

when done exit the vb editor but clicking the red X.
exit design mode but click the protractor on the control toolbox. close the
control toolbox.
test the check box. post back if problems.

regards
FSt1

"James" wrote:

It would be good if i could hide rows 20-25 with a check box if that's
possible.

"FSt1" wrote:

hi
not cells....rows or columns. and you would be much better of using a check
box instead of an option button(radio). options button work better as a group
and not alone. a check box works much better if it's just the only one but
can work as a group.
what rows/columns do you want to show/hide?

regards
FSt1

"James" wrote:

Can i set up a radio button (the circle selection thing i think), that when
selected would then show certain cells in a worksheet or if it's not selected
it doesn't show the cells?

That works fine. How can i edit it to hide certain rows on all available
sheets?

"FSt1" wrote:

hi
very possible.
from the control toolbox(not the forms), select the checkbox and drag it to
where ever you want it. size it. you can resize the check box itself only the
lable that comes with it.
right click the checkbox, select view code. paste this code into it.
Private Sub CheckBox1_Click() 'this should default in
If CheckBox1.Value = True Then
Rows("20:25").Hidden = True
Else
Rows("20:25").Hidden = False
End If
End Sub 'this should default it

when done exit the vb editor but clicking the red X.
exit design mode but click the protractor on the control toolbox. close the
control toolbox.
test the check box. post back if problems.

regards
FSt1

"James" wrote:

It would be good if i could hide rows 20-25 with a check box if that's
possible.

"FSt1" wrote:

hi
not cells....rows or columns. and you would be much better of using a check
box instead of an option button(radio). options button work better as a group
and not alone. a check box works much better if it's just the only one but
can work as a group.
what rows/columns do you want to show/hide?

regards
FSt1

"James" wrote:

Can i set up a radio button (the circle selection thing i think), that when
selected would then show certain cells in a worksheet or if it's not selected
it doesn't show the cells?