VBA Clear/.value = ""

[MFish]

I'm having an issue with VBA Clear Command Button.

I have a textbox named, txtLoc (Location of my depot) and many more textboxes/comboboxes. I also have my clear command button named, cmdClear. I'm just trying to clear the data out of all my userform criteria but this code doesn't work...

Sub cmdClear_Click()

txtLoc.clear
txtName.clear
setfocus.txtLoc

End Sub

But, why does this one work...

Sub cmdClear_Click()

txtLoc.value = ""
txtName.value = ""
setfocus.txtLoc

End Sub

? I am the type to try to understand "Why" this or "Why" that way it must be written... Can someone send me to a link or just quickly explain why?
Also, on another note, can someone tell me how to make a box that shows my code I've written? I see it in other messages. Thanks.

 

[DanteAmor]

The .Clear property does not exist for a Texbox.
The property .Clear in a combobox is to remove the data added to the combo list; and also the data of the combobox.


To clean the textbox data can be:

    TextBox1.Value = ""
    TextBox1.Value = Null

To enter the code you must press the # icon (Wrap Code tags around selected text)

 

[My Aswer Is This]

To quickly clear all your UserForm Controls you can use a script like this

Private Sub CommandButton1_Click()
'Modified  5/14/2019  8:11:44 PM  EDT
For Each xControl In Me.Controls
        If TypeName(xControl) = "TextBox" Then xControl.Value = vbNullString
        If TypeName(xControl) = "ComboBox" Then xControl.Clear
        If TypeName(xControl) = "ListBox" Then xControl.Clear
        If TypeName(xControl) = "CheckBox" Then xControl.Value = False
        
Next xControl
End Sub

 

[eduzs]

You can try, if there's no problem unloading the userform:

Private Sub CommandButton1_Click()
Unload Me
UserForm1.Show
End Sub