+ Reply to Thread
Results 1 to 4 of 4

Checkbox or radio buttons that make other cells appear or disappear?

Hybrid View

  1. #1
    Registered User
    Join Date
    06-17-2014
    Location
    warren, PA
    MS-Off Ver
    2010
    Posts
    2

    Checkbox or radio buttons that make other cells appear or disappear?

    Hi,

    I am looking for a way that someone can answer a yes or no question, i.e. "are you a member of the golf club?" by using radio buttons or checkbox, or anything similar. Based on the answer, I would like cells to appear below the question, for example in B3 another question would be "how many guests would you like to invite?" and B2 would be their answer but is preset to "0"

  2. #2
    Forum Contributor
    Join Date
    06-11-2014
    MS-Off Ver
    Office 2003, 2007 & 2010
    Posts
    119

    Re: Checkbox or radio buttons that make other cells appear or disappear?

    This uses ActiveX Checkbox and assumes the row you want to hide or unhide is 3, change A3 accordingly

    Private Sub CheckBox1_Click()
    
        If ActiveSheet.CheckBox1.Value = True Then
    
            ActiveSheet.Range("A3").EntireRow.Hidden = False
    
        Else
        
            ActiveSheet.Range("A3").EntireRow.Hidden = True
            
        End If
        
    End Sub

  3. #3
    Registered User
    Join Date
    06-17-2014
    Location
    warren, PA
    MS-Off Ver
    2010
    Posts
    2

    Re: Checkbox or radio buttons that make other cells appear or disappear?

    I'm getting an error with this.

    Run-time error '1004':
    Unable to set the Hidden property of the Range class

  4. #4
    Forum Contributor
    Join Date
    06-11-2014
    MS-Off Ver
    Office 2003, 2007 & 2010
    Posts
    119

    Re: Checkbox or radio buttons that make other cells appear or disappear?

    Can you please post your workbook for review?

+ 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. How to collapse radio buttons and Group Boxes and make them invisible
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-17-2013, 11:04 PM
  2. [SOLVED] Locks pictures and radio buttons to cells
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-13-2013, 03:30 PM
  3. Replies: 10
    Last Post: 09-17-2013, 10:36 AM
  4. [SOLVED] Form w/ Textbox/Radio buttons/Checkbox and button to transfer to 2nd sheet as database
    By christlivethinme in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-27-2013, 02:24 PM
  5. Radio Buttons in cells without control toolbox
    By tracktor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-13-2009, 10:18 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