Si vous voulez une exception pour le texbox : ttva1
Private Sub CommandButton2_Click()
Dim ctl As Control
For Each ctl In Me.Controls
If TypeOf ctl Is MSForms.TextBox Or TypeOf ctl Is MSForms.ComboBox Then
If Right(ctl.Name, 1) = 1 Then
If Not ctl.Name = "ttva1" Then
ctl = ""
End If
End If
End If
Next
End Sub