Private Sub UserForm_Initialize()
ComboBox1.Clear
ComboBox1.AddItem "Janvier " + ActiveWorkbook.ActiveSheet.Name
ComboBox1.AddItem "Février " + ActiveWorkbook.ActiveSheet.Name
Private Sub CommandButtonValider_Click()
If ComboBox1 = "Janvier " + ActiveWorkbook.ActiveSheet.Name Or ComboBox1 = "Février " + ActiveWorkbook.ActiveSheet.Name Then
If ComboBox1 = "Janvier " + ActiveWorkbook.ActiveSheet.Name Then
macro1
End If
If ComboBox1 = "Février " + ActiveWorkbook.ActiveSheet.Name Then
macro2
End If