+ Reply to Thread
Results 1 to 6 of 6

How to make radio button appear and disappear based on a cell's value?

  1. #1
    Registered User
    Join Date
    04-23-2008
    Posts
    50

    How to make radio button appear and disappear based on a cell's value?

    Hello,
    I would like to make the radio button disappear when there is no value in cell H6. Can anyone please help?

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: How to make radio button appear and disappear based on a cell's value?

    Hello megtoma,

    The Code below is one way of doing it:

    Please Login or Register  to view this content.
    Hope that helps.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Registered User
    Join Date
    04-23-2008
    Posts
    50

    Re: How to make radio button appear and disappear based on a cell's value?

    Hi,
    Could you please provide me with a file. I am not sure where to paste that code...

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: How to make radio button appear and disappear based on a cell's value?

    Hello megtoma,

    Please see the attached sample Workbook.

    Regards.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-23-2008
    Posts
    50

    Re: How to make radio button appear and disappear based on a cell's value?

    Brilliant. Thank you very much. How can I alter the code that: Button1 disappears when there is no value in cell H6 AND Button2 disappears when there is value "YES" in cell H8. Your help is very much appreaciated.

  6. #6
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: How to make radio button appear and disappear based on a cell's value?

    Hello megtoma,

    Replace your Code with Code below:

    Please Login or Register  to view this content.
    Thank you for the Rep tap!

    Regards.

+ 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. Checkbox or radio buttons that make other cells appear or disappear?
    By mjennings1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2014, 12:03 PM
  2. [SOLVED] Fairly New to VBA problems with getting button to appear/disappear based on cell value
    By kinscy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-18-2014, 12:41 AM
  3. Replies: 7
    Last Post: 12-27-2012, 10:53 PM
  4. how chart make wid help of radio button
    By Anil2007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2009, 11:42 AM
  5. Make a button disappear
    By Aaron Howe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-22-2005, 12:05 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