Private Sub Bouton_Click()
Dim Num As Integer
Dim Cel As Range, Depart As String
With UserForm1
For Num = 1 To 21
.Controls("TextBox" & Num) = ""
Next Num
Range("F2:F" & Range("F" & Rows.Count).End(xlUp).Row).Interior.ColorIndex = xlNone
Set Cel = Columns("F").Find(what:=Bouton.Caption, LookIn:=xlValues, lookat:=xlPart)
If Not Cel Is Nothing Then
Depart = Cel.Address
Do
Cel.Interior.ColorIndex = 3
Set Cel = Columns("F").FindNext(Cel)
Loop While Depart <> Cel.Address
End If
Num = Val(Mid(Bouton.Name, Len("OptionButton") + 1))
.Controls("TextBox" & Num) = Application.CountIf(Columns("F"), "*" & Bouton.Caption & "*")
.Label1.Caption = Bouton.Caption & " : " & Application.CountIf(Columns("F"), "*" & Bouton.Caption & "*")
End With
End Sub