'Dans un Module
Public Sub EffaceTextBox(ByRef UForm As UserForm, ParamArray ExceptTextBoxes())
Dim Ctrl As Control, i As Long, bModif As Boolean
'Boucle pour tout les contrôle de UForm
For Each Ctrl In UForm.Controls
bModif = True
If TypeOf Ctrl Is MSForms.TextBox Then
For i = LBound(ExceptTextBoxes) To UBound(ExceptTextBoxes)
If Ctrl.Name = ExceptTextBoxes(i) Then
bModif = False
Exit For
End If
Next i
If bModif Then Ctrl.Value = vbNullString
End If
Next
Set Ctrl = Nothing
End Sub
'--------------------------------------------------------------------------------
'Dans n'importe quel UserForm, les TextBoxes rajoutés en paramètre ne seront pas affectés
Call EffaceTextBox(Me, "TextBox2", "TextBox4")