Hi
I have a vba userform with a frame (Frame1) that needs to be hidden until the value of textbox (Reason) is "Yes". I've entered the below vba but it doesn't work at all so I need some help please. I don't even know if I have chosen the correct declaration for this?
Private Sub UserForm_Change(ByVal Target As Range)
Application.ScreenUpdating = False
If Reason.Value = "Yes" Then
Frame1.Visible = True
Else
Frame1.Visible = False
End If
Application.ScreenUpdating = True
End Sub
**Edit: I should have added that I want the controls within the frame to be hidden along with the frame (not sure if it makes a difference to the code).
Bookmarks