I have a TextBox and a ComboBox on a worksheet, is it possible to hide them with option buttons?. So only
one box shows at a time.
Thanks Z
Option Button1 selected show TextBox
Option Button2 selected show ComboBox
I have a TextBox and a ComboBox on a worksheet, is it possible to hide them with option buttons?. So only
one box shows at a time.
Thanks Z
Option Button1 selected show TextBox
Option Button2 selected show ComboBox
hi Z,
Try these for toggling between hiding and unhiding
Textbox:
Combobox:Please Login or Register to view this content.
Please Login or Register to view this content.
Life's a spreadsheet, Excel!
Say thanks, Click *
I must be doing something wrong, no luck. Not sure putting code in right place?
You might have to change the names of the textbox and combobox based on the name in your worksheet. See if this attachment helps
That works Good, I will play around and see if I can get it to work with my sheet. I use 2 ActiveX( Optionbuttons) to make the choice. I have one (Textbox and one Combobox)
Z
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks