Private Sub ComboBox2_Change()
If ComboBox2.Text <> "" Then
Call Inscriptions
Else
Exit Sub
End If
End Sub
Private Sub Inscriptions()
Dim Sh As Worksheet, i As Long
If Me.ComboBox2.ListIndex = -1 Then Exit Sub
With Me.ComboBox1
.Clear
For i = 2 To Ws.Cells(Me.ComboBox2.Column(1), Columns.Count).End(xlToLeft).Column
.AddItem Ws.Cells(Me.ComboBox2.Column(1), i)
Next i
End With
Label2.Visible = True
ComboBox1.Visible = True
For Each Sh In Worksheets
If Sh.Name = ComboBox2.Text Then Sh.Activate
Next Sh
End Sub
Private Sub CommandButton1_Click()
Dim derlig As Long, Reponse
Reponse = MsgBox("Confirmez vous l'ajout de la fiche " & ComboBox1, vbYesNo, "Attention")
If Reponse = vbYes Then
With ActiveSheet
derlig = .Range("a" & Rows.Count).End(xlUp).Row
If derlig = 1 Then
derlig = 3
Else
derlig = derlig + 1
End If
.Range("A" & derlig) = ComboBox1.Value
.Range("L" & derlig) = TextBox2.Value
End With
Else
Unload Me
End If
End Sub