Public MessageValidite As String
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
MessageValidite = "Absence info :" & Chr(10)
' With Sheets("notes")
' .Activate
If Cells(Target.Row, 1) = "" Then MessageValidite = MessageValidite & "- Numéro de matricule." & Chr(10)
If Cells(Target.Row, 2) = "" Then MessageValidite = MessageValidite & "- Nom." & Chr(10)
If Cells(Target.Row, 3) = "" Then MessageValidite = MessageValidite & "- Prénom." & Chr(10)
If Cells(Target.Row, 4) = "" Then MessageValidite = MessageValidite & "- Sexe." & Chr(10)
If Cells(Target.Row, 5) = "" Then MessageValidite = MessageValidite & "- Classe." & Chr(10)
If Cells(Target.Row, 6) = "" Then MessageValidite = MessageValidite & "- Matière."
If MessageValidite <> "Absence info :" & Chr(10) Then
MsgBox MessageValidite & Chr(10) & Chr(10) & "Remplissez toutes les colonnes !", vbCritical
Exit Sub
End If
' End With
Cancel = True 'annulation blocage curseur dans la cellule suite au dble clic
notes.Show
End Sub