Private Sub CommandButton1_Click()
Dim ws As Worksheet, x As Range
For Each ws In Worksheets
If ws.Name Like "U*" Then
Set x = ws.Range("B9:B40").Find(TextBox1, , xlValues, xlWhole, , , False)
If Not x Is Nothing Then Application.Goto x, True: Exit Sub
End If
Next ws
If x Is Nothing Then MsgBox "Non trouvé..."
End Sub