+ Reply to Thread
Results 1 to 5 of 5

If TextBox has value set visible other TextBoxes, if not set false

  1. #1
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    If TextBox has value set visible other TextBoxes, if not set false

    Hi,
    I would like to have some TextBoxes visible if I have values in other Textboxes.
    I tried to set the textboxes to false ....but I could not figure out. I attached a sample file with "before" and "after.
    I appreciate your time and help!
    Attached Files Attached Files
    Last edited by john55; 10-02-2011 at 02:53 PM. Reason: added more examples
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: TextBox visible or false

    hi, john55, sort of that, example for Textboxes: 20; 21, 28 (new code commented before and after)
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: TextBox visible or false

    hi watersev,
    Thank you for your help! it works if I display 0300, if I display 0400 where the textboxes21 and 28 have values it should show me the time (textboxes 26 and 27 and txtboxes 29 and 30).
    for 0500 you can see there are 2 cases, the firs one has 2 sectors and it works fain, the second one has 3 sectors and it shold display the time for the last sector.
    thank you again

  4. #4
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: If TextBox has value set visible other TextBoxes, if not set false

    hi, John, please check if that's what you are after
    Attached Files Attached Files

  5. #5
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: If TextBox has value set visible other TextBoxes, if not set false

    thank you for your help. yes, it's what I am looking for! it works!!!!!
    thx again!


+ 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