Hi guys,
I need some help with setting a trigger cell range based on input from another cell.
In cell C24, their is a drop down selection that allows you to select CR or PASS
In cell C25, their is another drop down that allows you to select Lw-Lw or Lw-Up
Based on input from cell C24 and C25, rows 35 and 39 are both displayed. This is not what I want to do.
If I select CR in cell C24 and Lw-Lw in cell C25, I only want row 39 to be displayed.
I need a way for my code to identify whether I select CR or PASS in cell C24 and then display the appropiate row when I select Lw-Lw instead of displaying both rows.
I need some help with setting a trigger cell range based on input from another cell.
In cell C24, their is a drop down selection that allows you to select CR or PASS
In cell C25, their is another drop down that allows you to select Lw-Lw or Lw-Up
Based on input from cell C24 and C25, rows 35 and 39 are both displayed. This is not what I want to do.
If I select CR in cell C24 and Lw-Lw in cell C25, I only want row 39 to be displayed.
I need a way for my code to identify whether I select CR or PASS in cell C24 and then display the appropiate row when I select Lw-Lw instead of displaying both rows.
VBA Code:
Set Triggercell = Range("C25")
If Not Application.Intersect(Triggercell, Target) Is Nothing Then
If Triggercell.value = "Lw-Lw" Then
Rows("35").Hidden = False
Rows("32:34").Hidden = True
ElseIf Triggercell.value = "" Then
Rows("32:35").Hidden = True
End If
End If
Set Triggercell = Range("C25")
If Not Application.Intersect(Triggercell, Target) Is Nothing Then
If Triggercell.value = "Lw-Lw" Then
Rows("39").Hidden = False
Rows("36:38").Hidden = True
ElseIf Triggercell.value = "" Then
Rows("36:39").Hidden = True
End If
End If