Hide\Unhide cell based on cell value !!!

[hensleyj]

Hey anyone,

I am having problems trying to work out a macro to hide/unhide a cell based on a value. The value is derived from a IF statement.

Below is the information you may need, any help would be appreciated. I have looked through the forums and used other suggestions for other posts, but none seem to work.

C14= =IF(C10="","",IF(OR(AND(C10="Business Super Directions"),AND(C10="Personal Super Directions")),"Yes","No"))

So, depending on the selection at C10 from a drop down box, C14 will equal the following;

1) BLANK, if C10 option has yet to be selected
2) Yes
3) No

What i am trying to do is the following;

1) BLANK: Show row 15
2) Yes: Show row 15
3) No: Hide row 15

As the value of C14 could change i need the macro to be able to show the above 3 outcomes.
If the cell changes from No to yes, i need it to unhide the cell.

Also, i have seen in some posts, others were having problems with the cell hiding or unhiding unless you hit the enter button.

I am hoping that it is possible for the macro to RUN and hide/unhide purely on the change of value without the need to hit "enter"

Any help would be really appreciated

 

[hensleyj]

i finally got it....after crawling through a lot of forums i highjacked one that finally worked. I really dont know why the recommendations above didnt work *shrug*

Sub PG1()

    If Range("C14").Value = "No" Then
        Rows("15:15").EntireRow.Hidden = True
    ElseIf Range("c14").Value = "Yes" Then
        Rows("15:15").EntireRow.Hidden = False
    End If


End Sub


Private Sub Worksheet_Change(ByVal Target As Range)
    If Range("C14").Value = "No" Then
        Rows("15:15").EntireRow.Hidden = True
    ElseIf Range("C14").Value = "Yes" Then
        Rows("15:15").EntireRow.Hidden = False


    End If
End Sub