+ Reply to Thread
Results 1 to 4 of 4

Automatically Hide Textbox with Hidden Rows

  1. #1
    Registered User
    Join Date
    03-26-2015
    Location
    USA
    MS-Off Ver
    2010, 2013
    Posts
    35

    Automatically Hide Textbox with Hidden Rows

    Hello,

    I have a sheet with hundreds of required Textboxes. These textboxes are aligned to grid and placed hovering over rows that contain corresponding information.

    In short, when I hide a row, I wish to have the textbox hide with the row rather than it moving up the sheet where it stacks on top of other textboxes and is no longer in the appropriate spot.

    I would also like it to unhide when I unhide the row.

    Thank you for your help!

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Automatically Hide Textbox with Hidden Rows

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    03-26-2015
    Location
    USA
    MS-Off Ver
    2010, 2013
    Posts
    35

    Re: Automatically Hide Textbox with Hidden Rows

    I attempted to attach a document, but I am unable to do so in this forum.

    I insert a Text Box, I size it so that it is the same height as the row I have placed it above, and when I hide the row sometimes the text box will hide, other times it will not hide.

    When it does not hide, it results in stacking on top of other text boxes.

    I need it to be affixed to the row I place it above so that when I hide the row, the text box always hides and reappears when I unhide the row.

  4. #4
    Registered User
    Join Date
    03-26-2015
    Location
    USA
    MS-Off Ver
    2010, 2013
    Posts
    35

    Re: Automatically Hide Textbox with Hidden Rows

    Grouping.xlsx

    Got it attached.

    See how when you close the grouping, the text boxes stack up at the top? I need the text boxes to also hide with the closed grouping.

    Never mind the rest of the attached. I just need to focus on the pesky text boxes.

    Thanks!

+ 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. Need code to hide and unhide a row based on if other rows are hidden or unhidden
    By aradov in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-20-2014, 02:06 PM
  2. Need a macro that automatically adjusts row numbers when rows are hidden
    By Esuric in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2014, 11:45 AM
  3. [SOLVED] Hide Row if Rows are Hidden
    By reba0729 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-22-2013, 04:22 PM
  4. Hide a row if rows below it are hidden
    By reba0729 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2013, 09:19 AM
  5. [SOLVED] Extra rows being hidden in loop to hide rows
    By gtol in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-11-2013, 07:33 AM
  6. Hide checkbox when rows are hidden
    By akaempfe in forum Excel Programming / VBA / Macros
    Replies: 38
    Last Post: 10-08-2012, 01:44 PM
  7. Hide rows if rows XX are hidden
    By ph8 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2005, 05:53 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