show different areas of sheet with a click radio button

S

Sean

I want to be able to show more or less of the screen by clicking a radio
button.

I have a VB script as below (first bit shown only)

I have in E2 (merged cell) 13 radio buttons 1-13

By clicking on the corresponding radio button - it will show as much of the
worksheet that is necessary.

The worksheet contains almost exactly the same going downward 13 times for
producing a site survey, for different size sites

Private Sub Trading Areas_1_Click()

If Me.Trading Areas_1.Value = -1 Then
Rows("36:452").Hidden = True
End If

End Sub



Private Sub Trading Areas_2_Click()

If Me.Trading Areas_2.Value = -1 Then
Rows("36:70").Hidden = False
Rows("71:452").Hidden = True
End If

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To be able to show only certain sections of worksheet 1
Radio Button Macro 3
Run-Time Error 1004/ unable to set the hidden property of the rang 1
Command Button to show/hide a different worksheet 1
radio button help 3
show hide row if 2
Radio Buttons on Sheets 4
Compare two different workbook sheet to show the difference in text 0

Top