+ Reply to Thread
Results 1 to 5 of 5

Hide TextBox with OptionButton

  1. #1
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Hide TextBox with OptionButton

    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

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Hide TextBox with OptionButton

    hi Z,

    Try these for toggling between hiding and unhiding

    Textbox:
    Please Login or Register  to view this content.
    Combobox:
    Please Login or Register  to view this content.
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Hide TextBox with OptionButton

    I must be doing something wrong, no luck. Not sure putting code in right place?

  4. #4
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Hide TextBox with OptionButton

    You might have to change the names of the textbox and combobox based on the name in your worksheet. See if this attachment helps
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Hide TextBox with OptionButton

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1