Hello All,
Seeking some assistance, thanks in advance to anyone that can assist !
I placed 5x Radio Buttons to use for filtering the ranges of data i have.
Range1 = 14-33
Range2 = 37-56
Range3 = 60-79
Range4 = 83-102
I also have a header range of 1-13 which must always be visible.
When i select the radio button i must click it again to disable the selection before i can choose another, i was of the understanding that the radio button reset the existing selection when you select another?
Here's my code:
Sub OptionButton15_Click()
Range("34:1000").EntireRow.Hidden = Not Range("34:1000").EntireRow.Hidden
End Sub
Sub OptionButton16_Click()
Range("14:36,57:1000").EntireRow.Hidden = Not Range("14:36,57:1000").EntireRow.Hidden
End Sub
Sub OptionButton17_Click()
Range("14:59,80:1000").EntireRow.Hidden = Not Range("14:59,80:1000").EntireRow.Hidden
End Sub
Sub OptionButton18_Click()
Range("14:82,103:1000").EntireRow.Hidden = Not Range("14:82,103:1000").EntireRow.Hidden
End Sub
Sub OptionButton19_Click()
Range("1000:1001").EntireRow.Hidden = Not Range("1000:1001").EntireRow.Hidden
End Sub
Seeking some assistance, thanks in advance to anyone that can assist !
I placed 5x Radio Buttons to use for filtering the ranges of data i have.
Range1 = 14-33
Range2 = 37-56
Range3 = 60-79
Range4 = 83-102
I also have a header range of 1-13 which must always be visible.
When i select the radio button i must click it again to disable the selection before i can choose another, i was of the understanding that the radio button reset the existing selection when you select another?
Here's my code:
Sub OptionButton15_Click()
Range("34:1000").EntireRow.Hidden = Not Range("34:1000").EntireRow.Hidden
End Sub
Sub OptionButton16_Click()
Range("14:36,57:1000").EntireRow.Hidden = Not Range("14:36,57:1000").EntireRow.Hidden
End Sub
Sub OptionButton17_Click()
Range("14:59,80:1000").EntireRow.Hidden = Not Range("14:59,80:1000").EntireRow.Hidden
End Sub
Sub OptionButton18_Click()
Range("14:82,103:1000").EntireRow.Hidden = Not Range("14:82,103:1000").EntireRow.Hidden
End Sub
Sub OptionButton19_Click()
Range("1000:1001").EntireRow.Hidden = Not Range("1000:1001").EntireRow.Hidden
End Sub