+ Reply to Thread
Results 1 to 5 of 5

How to hide textbox in userform and unhide it by check box?

  1. #1
    Registered User
    Join Date
    06-07-2018
    Location
    LA
    MS-Off Ver
    2016
    Posts
    15

    How to hide textbox in userform and unhide it by check box?

    How to hide textbox on userform and unhide it by check box?
    I've tried to use that code
    Please Login or Register  to view this content.
    I can't hide textbox7 by defaults...

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,071

    Re: How to hide textbox in userform and unhide it by check box?

    Put this
    Please Login or Register  to view this content.
    in the Initialize event

  3. #3
    Registered User
    Join Date
    05-09-2019
    Location
    St. Louis, USA
    MS-Off Ver
    2013
    Posts
    9
    Quote Originally Posted by Alex009988 View Post
    How to hide textbox on userform and unhide it by check box?
    I've tried to use that code
    Please Login or Register  to view this content.
    I can't hide textbox7 by defaults...
    I'm assuming this is all in Userform1. Try the Checkbox1_click event to be Me.Textbox7.visible = me.Checkbox1.value

    Then in the Userform1_initialize put me.textbox7.visible = False. You might also want to take out the Textbox7_change event. As you have it currently if you type in that textbox (make a change) then it will immediately become not visible.

  4. #4
    Registered User
    Join Date
    06-07-2018
    Location
    LA
    MS-Off Ver
    2016
    Posts
    15

    Re: How to hide textbox in userform and unhide it by check box?

    Thank you. This works.
    Please Login or Register  to view this content.
    When I tick checkbox the textbox appears as it should be, when I untick it, texbox7 still appears(unhidden). How to make the appearence dependable on check box?
    Edit. runfunke answer solved the problem
    Last edited by Alex009988; 07-17-2019 at 12:09 PM.

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,071

    Re: How to hide textbox in userform and unhide it by check box?

    You're welcome & thanks for the feedback

+ 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. How to Hide and Unhide the TextBox using CommandButton
    By jayvillalobos123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2017, 10:40 PM
  2. Unhide/hide textbox with option button
    By wrybel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2016, 09:21 AM
  3. [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
  4. Hide/Unhide Check Box Help - Different
    By AreJay0711 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-01-2016, 03:15 PM
  5. [SOLVED] Check Box - Hide / Unhide Information
    By KateMaz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-20-2016, 07:29 AM
  6. [SOLVED] hide/unhide textbox
    By sujimon in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-22-2013, 05:23 AM
  7. Hide/unhide row using check box ***PLEASE HELP***
    By madaleck1 in forum Excel General
    Replies: 6
    Last Post: 09-22-2011, 02:31 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