Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
show different areas of sheet with a click radio button
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not able to Click Button placed in the Work Sheet | Excel Worksheet Functions | |||
How do I create a separate radio button set in the same sheet? | Excel Discussion (Misc queries) | |||
radio button help | Excel Worksheet Functions | |||
How do I lock a radio button group if a N/A button is selected | Excel Discussion (Misc queries) | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions |