+ Reply to Thread
Results 1 to 4 of 4

How to Hide and Unhide the TextBox using CommandButton

  1. #1
    Registered User
    Join Date
    02-22-2017
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    17

    Question How to Hide and Unhide the TextBox using CommandButton

    Guys help me i have a Textbox1,2,3 and i have 1 commandbutton only how to open TB2 then close the TB1 and close the TB2 then open TB3 repeatedly

    Thank you and advance

  2. #2
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Slough
    MS-Off Ver
    Excel 2007
    Posts
    469

    Re: How to Hide and Unhide the TextBox using CommandButton

    Sorry. This doesn't make sense, when do you want the textboxes closed? Please explain in more detail what you want to do.

  3. #3
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016 (preparing to update to 2021)
    Posts
    7,544

    Re: How to Hide and Unhide the TextBox using CommandButton

    Take a look here, it's the same principle

    http://www.excelforum.com/excel-prog...ml#post4591724

    Instead of a picture it's a textbox, you could place that part of the code in the command button macro
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  4. #4
    Registered User
    Join Date
    02-22-2017
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    17

    Re: How to Hide and Unhide the TextBox using CommandButton

    thank you guys.
    now i know the solution
    CASE code

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Unhide/hide textbox with option button
    By wrybel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2016, 09:21 AM
  2. [SOLVED] Hide / unhide textbox based on label caption
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2016, 01:35 AM
  3. Unhide rows on commandbutton clicks
    By milo1984 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2016, 09:29 PM
  4. [SOLVED] value for textbox goes to commandbutton
    By aimjhun in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-09-2013, 09:54 PM
  5. [SOLVED] hide/unhide textbox
    By sujimon in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-22-2013, 05:23 AM
  6. [SOLVED] Hide & UnHide worksheet with commandbutton
    By zplugger in forum Excel General
    Replies: 23
    Last Post: 08-17-2012, 11:21 PM
  7. Link commandbutton to textbox
    By ncaravela in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-22-2010, 12:51 PM

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