CodeItBetter Programming Another VB Programming Blog

'Controls - How to Clear all TextBoxes on the form
Option Explicit
 
Private Sub ClearTextBoxes()
    Dim ctl As Control
    ' Clear all the TextBoxes on the form.
    For Each ctl In Controls
        If TypeOf ctl Is TextBox Then ctl.Text = ""
    Next ctl
End Sub
 
Private Sub cmdClearText_Click()
    ClearTextBoxes
End Sub