If one of two OptionButton from Form Controls selected hide textbox

[wrybel]

Hi,

please help me write a macro to hide textbox when one of two optionbuttons is selected and unhide when the other is selected.

Thanks !

[Bernie Deitrick]

Please Login or Register  to view this content.

[wrybel]

Thanks Bernie but it works only for ActiveX. I need a solution for Form Controls OptionButton. Do you have any idea ?

[Bernie Deitrick]

You need to assign macros to your two option buttons, like

Please Login or Register  to view this content.

[wrybel]

Thanks for help Bernie. Can I ask you one more question? Is it possible to assign a macro only to one option button and do the process of hiding/unhiding textbox. The option button might be in a group of course.

[Bernie Deitrick]

Not really. Once an option button is selected, then it cannot be re-clicked to change it. Another button on the same frame needs to be clicked to clear it.