Results 1 to 5 of 5

Userform Option Button to Show/Hide Another Option Button on same Userform

Threaded View

R_S_6 Userform Option Button to... 08-26-2010, 08:53 AM
Andy Pope Re: Userform Option Button to... 08-26-2010, 08:56 AM
R_S_6 Re: Userform Option Button to... 08-26-2010, 09:11 AM
Andy Pope Re: Userform Option Button to... 08-26-2010, 09:14 AM
R_S_6 Re: Userform Option Button to... 08-26-2010, 09:44 AM
  1. #1
    Forum Contributor
    Join Date
    07-28-2008
    Location
    Leamington Spa, UK
    MS-Off Ver
    2010
    Posts
    142

    Question Userform Option Button to Show/Hide Another Option Button on same Userform

    Hi All,

    I have a userform that has two checkboxes - 'OBTCL' & 'OBNAS'. When the value of 'OBTCL' is true I would like it to show an Option Button 'OBLabel'. If false then hide 'OBLabel'
    All the above are on the same userform - 'UserForm1'.

    I have tried the following:
    Sub UserForm1_Initialise()
    
    UserForm1.Me.Controls("OBLabel").Visible = False
    
        If OBTCL.Value = True Then
            UserForm1.Me.Controls("OBLabel").Visible = True
        Else
            If OBNAS.Value = True Or OBTCL.Value = False Then
                UserForm1.Me.Controls("OBLabel").Visible = False
            End If
        End If
    
    End Sub
    The above still shows 'OBLabel. I'm also not sure if i have put the code in the correct Sub, 'UserForm1_Initialise'?

    Any help on the above would be appreciated as always.
    Cheers,
    Mark
    Last edited by R_S_6; 08-27-2010 at 02:31 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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