Clear all text boxes-combo boxes in a userform.

**MariaPap** · 01-31-2014, 10:02 AM

Hello

Apologize in advance if the answer of my question is simple..

I use many series of textboxes and compo boxes in my userforms.

Until now i use something like this to clear the data into these.

qucase1.Value = ""
qucase2.Value = ""
qucase3.Value = ""
qucase4.Value = ""
qucase5.Value = ""

prcase1.Value = ""
prcase2.Value = ""
prcase3.Value = ""
prcase4.Value = ""
prcase5.Value = ""

valcase1.Value = ""
valcase2.Value = ""
valcase3.Value = ""
valcase4.Value = ""
valcase5.Value = ""

machcase1.Value = ""
machcase2.Value = ""
machcase3.Value = ""
machcase4.Value = ""
machcase5.Value = ""

comcase1.Value = ""
comcase2.Value = ""
comcase3.Value = ""
comcase4.Value = ""
comcase5.Value = ""

TextBox15.Value = ""
TextBox4.Value = ""
ComboBox1.Text = ""

It's really hard..

Is there any other way to clear ALL the qucases, ALL the prcases...etc using 1 line of code?

Thanks in advance for any assistance here!

**AndyLitch** · 01-31-2014, 10:22 AM

One very simple method would be to unload and reload the userform.

Unload Me 
UserForm1.Show

**buran** · 01-31-2014, 10:30 AM

if for some reason you don't want to unload/show form another way is to loop trough the controls and check their type. In the code I assume your form name is UserForm1

Sub ClearTextAndComboBoxes()
    Dim objControl As MSForms.Control
        For Each objControl In UserForm1.Controls 'change the name of the form
            If TypeOf objControl Is MSForms.TextBox Or TypeOf objControl Is MSForms.ComboBox Then
                objControl.Value = vbNullString
            End If
        Next objControl
End Sub

**MariaPap** · 01-31-2014, 11:16 AM

buran

Thank you. This does exactly what i need!!

Andy thanks for the assist here!

Clear all text boxes-combo boxes in a userform.

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Clear all text boxes-combo boxes in a userform.

Re: Clear all text boxes-combo boxes in a userform.

Re: Clear all text boxes-combo boxes in a userform.

Re: Clear all text boxes-combo boxes in a userform.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Help with code for userform text boxes, combo boxes and excel

Using the If function to set parameters on Text and Combo boxes on a userform

Selected data from combo boxes to text boxes

Combo Boxes / Text Boxes Not Updating

Auto populating UserForm Combo and Text boxes from Validated data sets

Bookmarks

Bookmarks

Posting Permissions