Results 1 to 10 of 10

Userform Behaviour

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-06-2012
    Location
    Toronto, ON
    MS-Off Ver
    Office 365
    Posts
    138

    Userform Behaviour

    Hello,

    Ill post my simple code below - what Im really wondering is how I would do this (if its even possible)...Im using a userform and I have two checkboxes, a 'Yes' and 'No'..........Im wondering if the 'Yes' is checked I would like the userform to extend and another question to appear on the userform. If the No is checked, then the form doesnt have to do anything.

    So this is what I got - was hoping someone could tell me how to make that happen, if its possible.

    Thanks



    ..................
    
    Private Sub CheckBox1_Click()
        If CheckBox1.Value = True Then
        Me.TextBox4 = "It appears you clicked yes"
        Me.TextBox5 = "The Question here............................"
        UserForm1.CheckBox2.Value = False
        Else
        CheckBox1.Enabled = True
        End If
        End Sub
    Last edited by excelenergy; 07-07-2014 at 02:47 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 02-27-2013, 12:04 PM
  2. Tabbing throug userform's Textboxes, Changing defauld behaviour
    By vin1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-15-2012, 08:38 AM
  3. Userform Textbox Behaviour
    By payney in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2010, 10:06 AM
  4. [SOLVED] Odd Add-in behaviour
    By Pete Church in forum Excel General
    Replies: 0
    Last Post: 03-01-2006, 10:30 AM
  5. Odd Behaviour
    By SteveW in forum Excel General
    Replies: 1
    Last Post: 03-07-2005, 08:54 AM

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