Dim Compteur as integer
For i=1 to 30
If me.controls("Textbox" & i).value= .....then compteur=compteur +1
next
If Compteur = 30 then Msgbox("condition OK")
....
With UserForm1 'ou With Me
For x = 1 to 30
If .Controls("TextBox" & x) = ... Then
...
End If
End With