Private Sub ComboBox1_Change()
On Error Resume Next
Sheets(Trim(ComboBox1)).Activate
If Err Then MsgBox "La feuille " & Trim(ComboBox1) & " n'existe pas...", 48
End Sub
Private Sub ComboBox1_Change()
On Error Resume Next
Sheets(Trim(ComboBox1)).Activate
If Err Then MsgBox "La feuille " & Trim(ComboBox1) & " n'existe pas...", 48
[COLOR="Red"]If Range(ComboBox1.ListFillRange).Count = Sheets.Count - 2 Then Exit Sub 'mettre en commentaire pour la 1ère fois[/COLOR]
Dim i As Integer
For i = 2 To Sheets.Count - 1
Sheets("Listes").Range("A3").Offset(i) = " " & Sheets(i).Name
Next
End Sub
Private Sub ComboBox1_Change()
On Error Resume Next
Sheets(Trim(ComboBox1)).Activate
If Err Then MsgBox "La feuille " & Trim(ComboBox1) & " n'existe pas...", 48
If [COLOR="Red"][ListeMois][/COLOR].Count = Sheets.Count - 2 Then Exit Sub 'mettre en commentaire pour la 1ère fois
Dim i As Integer
For i = 2 To Sheets.Count - 1
Sheets("Listes").Range("A3").Offset(i) = " " & Sheets(i).Name
Next
End Sub
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If [ListeMois].Count = Sheets.Count - 2 Then Exit Sub 'mettre en commentaire pour la 1ère fois
Dim i As Integer
For i = 2 To Sheets.Count - 1
Sheets("Listes").Range("A3").Offset(i) = " " & Sheets(i).Name
Next
End Sub
Private Sub ComboBox1_Change()
On Error Resume Next
Application.EnableEvents = False
Sheets(Trim(ComboBox1)).Activate
Application.EnableEvents = True
If Err Then MsgBox "La feuille " & Trim(ComboBox1) & " n'existe pas...", 48
End Sub
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Dim i As Integer
Sheets("Listes").Range("A5:A65536").ClearContents
For i = 2 To Sheets.Count - 1
Sheets("Listes").Range("A3").Offset(i) = " " & Sheets(i).Name
Next
End Sub