Public Function Compter(InChaine As String, InChar1 As String) As Long Dim Pos As Integer Compter = 0 InChar1 = Left$(InChar1, 1) Pos = 0 Do Pos = InStr(Pos + 1, InChaine, InChar1) If (Pos > 0) Then Compter = Compter + 1 'Else End If Loop Until Pos = 0 End Function