Can user form fields be depenent upon the answer to another field?

**aliciaward1001** · 09-18-2017, 04:15 PM

I'm making a user form with multiple checkboxes. I'd like to have a text box pop up only if the checkbox is checked. Is that possible?

**MarvinP** · 09-18-2017, 04:27 PM

Hi Alicia,

See the attached with some simple code that does what I think you want.

Private Sub CheckBox1_Click()
 If Me.CheckBox1.Value = True Then
        Me.TextBox1.Visible = False
    Else
        Me.TextBox1.Visible = True
    End If
End Sub

CheckBox show TextBox if clicked.xlsm

**aliciaward1001** · 09-18-2017, 05:01 PM

Thanks
* for you both

**aliciaward1001** · 09-20-2017, 09:43 AM

OMG nevermind. I forgot to change Visible to False

**davesexcel** · 09-18-2017, 04:34 PM

Probable just use the value of the checkbox,

Private Sub CheckBox1_Click()
    x = Me.CheckBox1.Value
    Me.TextBox1.Visible = x
End Sub

Or even

Private Sub CheckBox1_Click()
    Me.TextBox1.Visible = Me.CheckBox1.Value
End Sub

**aliciaward1001** · 09-20-2017, 09:19 AM

I've used all 3 of these and they all work, however, when the user form opens all of the text fields are visible. Only once the box is checked and then unchecked the text field becomes hidden. How can I adjust this to hide the text fields when the user form opens?

**nigelog** · 09-20-2017, 09:30 AM

In initialize code

Me.TextBox1.Visible = False
Me.TextBox2.Visible = False
Me.TextBox3.Visible = False

etc

OR

Dim ctrl As Control 
For Each ctrl In Me.Controls 

 If TypeOf ctrl Is msforms.TextBox Then 
 ctrl.Visible = False 
 End If 

Next

Can user form fields be depenent upon the answer to another field?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Can user form fields be depenent upon the answer to another field?

Re: Can user form fields be depenent upon the answer to another field?

Re: Can user form fields be depenent upon the answer to another field?

Re: Can user form fields be depenent upon the answer to another field?

Re: Can user form fields be depenent upon the answer to another field?

Re: Can user form fields be depenent upon the answer to another field?

Re: Can user form fields be depenent upon the answer to another field?

Thread Information

Users Browsing this Thread

Similar Threads

Creating a User Form Template with Dynamic fields

[SOLVED] User Form Required Fields

User Form Date fields error out

User form which having some fields to be entered only once.

How to Display All the fields into User Form When selecting any row

Filling form fields via worksheet dropdowns, user update via form, change form color

Best way to fill user form fields

Bookmarks

Bookmarks

Posting Permissions