Forum Discussion

KyHeffernan's avatar
KyHeffernan
Copper Contributor
Mar 06, 2020
Solved

Using vba to hide rows from multiple data validation drop down boxes

Hi, I'm trying to figure out how to get a macro to hide a row in excel if "No" is selected in two different drop down boxes.    I had a go at using the code below to hide a row based on a single dr...
excel
Formulas and Functions
Macros and VBA
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Mar 06, 2020

    KyHeffernan 

    This code will achieve what you want. In this example your two triggers are in E5 and F5.

    Private Sub Worksheet_Change(ByVal Target As Range)

Dim TriggerCell1, TriggerCell2 As Range
Set TriggerCell1 = Range("E5")
Set TriggerCell2 = Range("F5")

    If TriggerCell1.Value = "No" And TriggerCell2.Value = "No" Then
        Rows("6").Hidden = True
        Else
        Rows("6").Hidden = False
    End If

End Sub

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Mar 06, 2020

KyHeffernan 

This code will achieve what you want. In this example your two triggers are in E5 and F5.

Private Sub Worksheet_Change(ByVal Target As Range)

Dim TriggerCell1, TriggerCell2 As Range
Set TriggerCell1 = Range("E5")
Set TriggerCell2 = Range("F5")

    If TriggerCell1.Value = "No" And TriggerCell2.Value = "No" Then
        Rows("6").Hidden = True
        Else
        Rows("6").Hidden = False
    End If

End Sub

 

Resources