Private Sub valide_Click()
Sheets("Feuil1").Activate
Range("B20") = entree.nom.Value
Range("C20") = entree.prenom.Value
Range("B5:C20").Select
Selection.Sort Key1:=Range("B4"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
Range("d3").Select
If (nom.Value <> "") Then
Unload entree
Else
MsgBox " Veuillez inscrire le NOM"
End If
End Sub