VBA Code to hide/unhide rows when a something is selected from drop down list.

[Essencex]

Hi I cannot figure this out for the life of me!
I need a code that will unhide rows 8-47 when 'Yes - Answer questions below' is selected in drop down list of cell E7.

The same goes for the following on the same sheet:
I need a code that will unhide rows 57-91 when 'Yes - Answer questions below' is selected in drop down list of cell E56.
*I guess I can just copy and paste the code for above and change it slightly for the second request?

hopefully someone can help

 

[Snakehips]

@Essencex Welcome
Try like this Change Event code. Paste into the sheet's code pane.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Count > 1 Then Exit Sub
    If Not Target = "Yes - Answer questions below" Then Exit Sub
    Select Case Target.Address
    Case "$E$7"
        Range("E8:E47").Rows.EntireRow.Hidden = False
        
    Case "$E$56"
        Range("E57:E91").Rows.EntireRow.Hidden = False
    Case Else
    End Select
    
End Sub

HTH

 

[Essencex]

Hi Tony, this absolutely worked thank you!! Ive tested it and near perfect...how do I, if the word 'Yes - Answer questions below' is de-selected from list how do i get it back to 're-hiding' the rows?

 

[Snakehips]

Hi, Try like..

Private Sub Worksheet_Change(ByVal Target As Range)
Dim HideRows As Boolean
    If Target.Count > 1 Then Exit Sub
    HideRows = Not Target = "Yes - Answer questions below"
    Select Case Target.Address
    Case "$E$7"
        Range("E8:E47").Rows.EntireRow.Hidden = HideRows
        
    Case "$E$56"
        Range("E57:E91").Rows.EntireRow.Hidden = HideRows
    Case Else
    End Select
    
End Sub

 

[Essencex]

thanks Toni! legend, it worked