Hide/Unhide Rows Based Upon Drop-Down Option Selected

[kkm_]

I know there is probably a simple way to do this, but I'm new to VBA. I have multiple drop-down lists and for some I am trying to unhide rows if a specific drop-down item is selected and rehide them if the drop-down item is later changed. For example, if in row 17 "Red" is selected, rows 18 and 19 will unhide but if "Green" is selected, rows 18 and 19 remain hidden or re-hide if "Red" was previously selected.

If you have any suggestions, please let me know! Thanks!

 

[lenze]

Hi and welcome to the board!!!
Your question is somewhat vague, but this should get you started

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$A$17" Then Exit Sub
Rows(18).EntireRow.Hidden = False
Select Case Target
Case "Red"
Rows(18).EntireRow.Hidden = True
Case "Green":
Case Else:
End Select
End Sub

In the worksheet module. RightClick the sheet tab and choose "View Code'
lenze