Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Target, Range("G10")) Is Nothing Then
If IsNumeric(Target) Then
Target = Target + 1
Else
MsgBox "Vous souhaitez un numéro... Rentrez une valeur numérique", vbCritical, "Oups !!!"
End If
Cancel = True
End If
End Sub