Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim Nb()
Nb = Array(1, 2, "")
On Error GoTo fin
Target.Value = Nb(Application.WorksheetFunction.Match(Target.Value, Nb, 0) Mod 3)
Cancel = True
Exit Sub
fin:
Target.Value = Nb(0)
Cancel = True
End Sub