Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Dim L As Long
Dim Entree As String * 6
Dim Chaine As String * 2
Dim Num As Double
Dim i As Integer
' Suivant plage ("C16:C65536")
' ==> Insertion Date J-1 dans Cellule Double-Clickée
If Not Intersect(Target, Range("C16:C65536")) Is Nothing Then
If ActiveCell.Value = "" Then ActiveCell.FormulaR1C1 = Format(Now - 1, "mm/dd/yyyy"): ActiveCell.Offset(1, 0).Select
End If
L = Target.Row
If Sh.Cells(L, 12).Value <> "" Then Chaine = "HA" Else Chaine = "BQ"
Do: L = L - 1
If Left$(Sh.Cells(L, 2).Value, 2) = Chaine Then
Sh.Cells(Target.Row, 2).Value = Chaine & Format(Right$(Sh.Cells(L, 2).Value, 3) + 1, "000")
Exit Do
End If
Loop
End Sub