Sub Depart()
Dim ListeNb As Variant
Dim Mdp As String
'Mot de passe
Mdp = InputBox("Mot de passe", "Saisir le ")
'Si mauvais mot de passe on sort
If Mdp <> "1998" Then Exit Sub
NbQTot = Sheets("QCM").Range("L2")
With Sheets("RESULT")
.Range("A2:A193,C2:C193").ClearContents
NbQ = Application.InputBox("NOMBRE DE QUESTIONS" & vbCrLf & "(Maximum " & NbQTot & " )", "QCM", Type:=1)
If NbQ = 0 Or NbQ > NbQTot Then Exit Sub
ListeNb = GenQ(NbQ, 1, NbQTot)
.Range(.Cells(2, 1), .Cells(NbQ + 1, 1)).Value = Application.Transpose(ListeNb)
End With
UserForm1.Show
End Sub