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
Bookmarks