VBA Code To hide rows based on a cell value.

[deanlongstaff]

I have a combo box linked to cell "AE1". When the value in ("AE1") is "Yes", i need rows 40:41 to hide. And when it shows "No" in the box, i need rows 40:41 to be visible again. It needs to work in real time. Can anyone help me with the VBA code for this? Thanks

 

[mole999]

this style of question has been asked and answered often, have a search of the forum, you will find many examples

 

[Yongle]

as @mole999 says, there are lots of similar examples if you search the forum

Are you using a Forms Control ComboBox (ie NOT active-x)?
Does selecting "yes" in the combobox return value 1 in cell AE1?

Try

Sub DropDown1_Change()
    With ActiveSheet
        .Rows("40:41").EntireRow.Hidden = (.Range("AE1").Value = 1)
    End With
End Sub

 

[deanlongstaff]

Hi, no it's active X i'm using. I did search but i can't seem to get any of them to work...

 

[My Aswer Is This]

Hi, no it's active X i'm using. I did search but i can't seem to get any of them to work...

How did you link a Activex Combobox

I know how to Link a FormControl

Are you sure it's a Activex Combobox?

 

[deanlongstaff]

I uses the properties window in the VBA window

 

[My Aswer Is This]

If your using a Activex Combobox I know of no way to link it
But you would use this script

Private Sub ComboBox1_Change()
'Modified  1/28/2019  6:24:46 AM  EST
If ComboBox1.Value = "Yes" Then Rows("40:41").Hidden = True
If ComboBox1.Value = "No" Then Rows("40:41").Hidden = False
End Sub

 

[deanlongstaff]

Thank you so much, been frustrated for hours :D

 

[My Aswer Is This]

Well I see now how you linked the Combobox but not sure why you think you need to do that.
That's not needed

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Thank you so much, been frustrated for hours :D