Unhide/hide textbox with option button

**wrybel** · 09-26-2016, 08:09 AM

Hi all,

please help me with this macro. I have 2 option buttons in GroupBox. I would like to have one macro, which shows a texbox when first option button is selected and hide text box when first option buttonis not selected.

Sub OptionButton1_Clik()
ActiveSheet.Shapes("text1").Visible = True
End Sub
Sub OptionButton2_Clik()
ActiveSheet.Shapes("text1").Visible = False
End Sub

Topic also on http://www.excelforum.pl/topics3/ukr...041.htm#303556

**MickG** · 09-26-2016, 09:16 AM

Try with Checkbox !!

Private Sub CheckBox1_Click()
With ActiveSheet.Shapes("TextBox1")
.Visible = Not .Visible
End With
End Sub

**wrybel** · 09-26-2016, 09:21 AM

I need to select one and unselect other. Check box doesn't have this option.

Unhide/hide textbox with option button

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Unhide/hide textbox with option button

Re: Unhide/hide textbox with option button

Re: Unhide/hide textbox with option button

Thread Information

Users Browsing this Thread

Similar Threads

Required macro with button/option to hide unhide several sheets

[SOLVED] Textbox and Option Buttons - If Textbox has a Value then an Option Button must be selected

[SOLVED] Need Option Button To Hide Or Unhide Worksheets

[SOLVED] hide/unhide textbox

Protect the Hide/Unhide option

Hide row if cell is a certain value, with unhide toggle option

Hide/Unhide Option - Need to consider all options!

Bookmarks

Bookmarks

Posting Permissions