userform to show based on cell value

[donny1shot]

Hi All,
I am trying to have a userform show if a cell value is selected as yes from it's drop down list.

any help please. Below is the code I am using in the userform code coding sheet.
Code:
Private Sub UserForm_activiate()
If Sheets("HCR").Range("C13").Text = "Yes" Then
UserForm1.Show
End If
End Sub
This isn't working for me I need the userform to show if YES is selected in that cell

 

[njimack]

Try the following in the module of your HCR sheet...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$13" And Target.Text = "Yes" Then Userform1.Show
End Sub

 

[donny1shot]

That's is working great thanks.