VBA to hide userform frame until condition met

[xybadog]

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?

Please Login or Register  to view this content.

**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).

[6StringJazzer]

I would try this.

Please Login or Register  to view this content.

If this does not work please attach your file. See yellow banner at the top of the page.

[xybadog]

I would try this.

Please Login or Register  to view this content.

If this does not work please attach your file. See yellow banner at the top of the page.

Hi

No, unfortunately, that didn't work so I've attached my file.

On the launcher, select "Employer Transfer", that is the userform with Frame1 and the textbox (NewL) that holds the "Yes" value. In my OP I stated the textbox was named Reason but that is incorrect, it is NewL

*Removed attachment

[xybadog]

I have actually found a way to make this work now. Rather than using the value of the textbox as a trigger I have used the option button click events that change that textbox value to hide/unhide the frame which was quite simple in the end.:

Please Login or Register  to view this content.