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 !
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 !
Please Login or Register to view this content.
Bernie Deitrick
Excel MVP 2000-2010
Thanks Bernie but it works only for ActiveX. I need a solution for Form Controls OptionButton. Do you have any idea ?
You need to assign macros to your two option buttons, like
Please Login or Register to view this content.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks