Change or Click event for a User Form option/radio button.

[batman37]

I have 2 option buttons in a frame on a user form. When one of them is clicked (changes), I want to trigger code that makes the visible property of a textbox (which is not in the frame) false, that is, hide the text box. I want to do this without having to click a command button first, through which I could detect the state of the option button and act accordingly. So far I can't find or identify an option button click event. Is there such a thing, and if so how do I implement it?

Thanks for any help, code snippets, or words of wisdom.

 

[Fluff]

Try double clicking the option button.

 

[batman37]

Thanks Fluff, and my apologies for taking so long to respond.
Your suggestion seemed to do the trick, although I was hoping for some specific click-event code.

 

[Fluff]

Simply put this code in one of the option button click events

   Me.TextBox1.Visible = False

& then the same again in the other one, but change False to True

 

[batman37]

Thanks, Fluff. Inserting that code does exactly what I want. It also leads me to try some other tricks with the click event. I consider this thread answered/solved, but I don't see a place or a button to so sdeclare.

 

[Fluff]

You're welcome & thanks for the feedback.

We don't mark threads as solved here.