There is no collection of TextBoxes, but there is one of all the
controls on a form  and using its typename you could do something like:


For Each ctl In UserForm1.Controls
If TypeName(ctl) = "TextBox" Then ctl.Text = ""
Next