Private Sub Worksheet_Change(ByVal Target As Range)
Dim Chemin as String
If Not Intersect(Target, Range("A1")) Is Nothing Then
Chemin= " C:\repertoire\sousrepertoire\" ' répertoire où se trouvent les sons, à adapter
Select Case Target.Value
Case 1
PlaySound Chemin & "Coyote.wav", 1, 1
Case 2
PlaySound Chemin & "Lapin.wav", 1, 1
Case 3
PlaySound Chemin & "Fourmi.wav", 1, 1
...
...
Case Else
MsgBox ("Selection erronée")
End Select
End If
End Sub