Macro based on multiple conditions

[Dhoffl]

I have a very limited understanding of macro and VBA

I am trying to make a hidden row appear only if the following conditions are met:

1. A specific option is selected from one drop down menu
2.Any of 4 options (mme, lc, isb or cre) are selected from another drop down list which contains multiple other options
2. At least two cells in a range of four cells are populated with "yes"

if not all criteria are met the row should remain hidden.

Any pointers on this would be great as I have been effectively teaching myself from YouTube and excel forums and have hit a wall on this one.

 

[JLGWhiz]

Assuming your first dropdown list is in cell A1 and you second dropdown list is in cell B1 and you range for the 'yes' critereis is C1:C4

If Range("A1").Value = "Specific Option" Then
    If Range("B2").Value = "mme" Or Range("B2").Value = "lc" Or Range("B2").Value = "isb" Or Range("B2").Value = "cre" Then
       If Application.CountI(Range("C1:C4"), "yes") = 2 Then
           Rows(5).Hidden = True
       End If
    End If
End If

 

[Dhoffl]

Thank you for sharing that. I get an error saying application doesnt support that object or method. It highlighting the row Application.countI

 

[Dhoffl]

Thank you for sharing that. I get an error saying application doesnt support that object or method. It highlighting the row Application.countI

Oops Sorry, ignore me I realise I needed it to be count if. thank you so much for your help!

 

[JLGWhiz]

Oops Sorry, ignore me I realise I needed it to be count if. thank you so much for your help!

Yes, it was a typo. Glad you could fix it.
Regards, JLG