+ Reply to Thread
Results 1 to 3 of 3

automatically hide and unhide a cell and cell range based on true or false statement

  1. #1
    Registered User
    Join Date
    07-27-2014
    Location
    los angeles
    MS-Off Ver
    2010
    Posts
    1

    automatically hide and unhide a cell and cell range based on true or false statement

    i need a vba code to hide and unhide a range of rows based on true or false radial button selection. If radial button is selected, i need a row to unhide and if the row isn't selected the row should remain hidden. the range of cells is about 50 rows which are populated with formulas and data will show based on radial selection. If one of the buttons on sheet 2 is selected, one of the rows on sheet 1 becomes unhidden and vice versa.
    Could someone help

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: automatically hide and unhide a cell and cell range based on true or false statement

    Hi,

    Your explanation is not very clear to me, so I will instead offer this hint...look up
    Please Login or Register  to view this content.
    I hope this helps

  3. #3
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: automatically hide and unhide a cell and cell range based on true or false statement

    Try this...

    Please Login or Register  to view this content.
    Remember changing the worksheetname accordingly..

    Don't forget to click *

+ 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. Automatically hide and unhide rows based on value in cell
    By kmham in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-28-2014, 12:03 PM
  2. Automatically hide columns and unhide of cell value(s) appear within a range
    By oddinho in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2013, 08:32 PM
  3. Hide Show rows based on cell value true or false using VBA
    By gopal904 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-12-2013, 07:31 AM
  4. [SOLVED] VBA code to hide/unhide sheets based on a tick-box (TRUE/FALSE)
    By kavindra in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-10-2013, 08:11 AM
  5. Replies: 3
    Last Post: 12-05-2011, 11:41 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