+ Reply to Thread
Results 1 to 6 of 6

control visibility of one cell, maybe using radio button

  1. #1
    Registered User
    Join Date
    05-21-2019
    Location
    Calgary, AB, Canada
    MS-Off Ver
    2010
    Posts
    3

    control visibility of one cell, maybe using radio button

    Hello

    I have an excel sheet with information in various cells.

    I would like to be able to turn visibility of one cell on or off when needed.
    I was thinking maybe using a radio button, but can't get that to work.
    Maybe wrong method.

    Any ideas anyone ??

    - see attachment
    - need to be able to hide or display value in cell E17

    Thank you
    Terry
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,087

    Re: control visibility of one cell, maybe using radio button

    You can't really hide a single cell. You can only hide full row(s) or full column(s). What you can do is change the font colour to the background colour but you'll also need to add, say, light grey border. Be careful with Conditional Formatting as you may need to use the same trick.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,482

    Re: control visibility of one cell, maybe using radio button

    Hi Terry,

    What you need to do is link the checkbox to a cell, I picked the cell it is in C17. when it is linked it will give that cell the value TRUE or FALSE depending on if it is checked or unchecked.
    you can set the linked cell by right clicking the checkbox and pick form control item at the bottom of the menu.

    then change the formula in E1 to
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    and that will make it possible to show a value or not.

    in the sheet I left the text color of C17 white so you can see what is happening but ofcourse in the final sheet you can give the text the same color as the background
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    05-21-2019
    Location
    Calgary, AB, Canada
    MS-Off Ver
    2010
    Posts
    3

    Re: control visibility of one cell, maybe using radio button

    Thank you for your reply TMS.

  5. #5
    Registered User
    Join Date
    05-21-2019
    Location
    Calgary, AB, Canada
    MS-Off Ver
    2010
    Posts
    3

    Re: control visibility of one cell, maybe using radio button

    Thank you Roel for your help.
    It worked perfectly !!

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,087

    Re: control visibility of one cell, maybe using radio button

    You're welcome.

+ 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. Replies: 1
    Last Post: 02-27-2017, 09:17 AM
  2. Radio Button to toggle YES or NO based on a cell value
    By egrospe17 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2016, 11:22 PM
  3. Replies: 3
    Last Post: 01-07-2015, 12:19 PM
  4. Control Radio Button With Conditions
    By dblcrona in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-21-2014, 05:52 PM
  5. [SOLVED] Help to control Frame visibility on Userform Initialized
    By odoualex in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-01-2013, 04:21 AM
  6. Pressing one radio button to select another radio button
    By raehippychick in forum Excel General
    Replies: 1
    Last Post: 09-13-2007, 11:30 PM
  7. Radio Button to discount value in cell
    By robhargreaves in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-11-2007, 04:10 PM

Tags for this Thread

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