Private Sub CommandButton1_Click()
ActiveCell.Offset(0, 0).Range("A1").Value = Nom_instrument
ActiveCell.Offset(0, 1).Range("A1").Value = Nom_membre
ActiveCell.Offset(0, 2).Range("A1").Value = Prénom_membre
ActiveCell.Offset(0, 3).Range("A1").Value = surnom_membre
ActiveCell.Offset(0, 4).Range("A1").Value = Adresse_membre
ActiveCell.Offset(0, 5).Range("A1").Value = Localité_membre
ActiveCell.Offset(0, 6).Range("A1").Value = Portable_membre
ActiveCell.Offset(0, 7).Range("A1").Value = Email_membre
ActiveCell.Offset(0, 8).Range("A1").Value = Date_Anniversaire
Unload Me '
End Sub
Private Sub Date_Anniversaire_CallbackKeyDown(ByVal KeyCode As Integer, ByVal Shift As Integer, ByVal CallbackField As String, CallbackDate As Date)
End Sub
Private Sub UserForm_Initialize()
Me.Nom_instrument.RowSource = "Feuil1!A49:A56"
End Sub
Private Sub Anniversaire_membre_CallbackKeyDown(ByVal KeyCode As Integer, ByVal Shift As Integer, ByVal CallbackField As String, CallbackDate As Date)
End Sub
Sub Action()
Dim vCellule As Object
Load UserForm1
For Each vCellule In Sheets("Types").Range("liste_instrument")
If vCellule.Value = "" Then Exit For
UserForm1.CmbListeTypes.AddItem vCellule.Value
Next
UserForm2.CmbListeTypes.ListIndex = 0
UserForm2.Show
End Sub