1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| Private Sub CommandButton1_Click()
Dim tablo(), mois As Variant, i As Integer, k As Integer
Dim Ctrl As Control, feuilles As Variant
k = 0
mois = Array("", "janvier", "fevrier", "mars", "avril", "mai", "juin", "juillet", "aout", "septembre", "octobre", "novembre", "decembre")
feuilles = Array("", "Janv", "Fev", "Mars", "Avr", "Mai", "Juin", "Juil", "Aout", "Sept", "Oct", "Nov", "Dec")
For i = 1 To 12
If Me.Controls("enr_" & mois(i)) Then
k = k + 1
ReDim Preserve tablo(k)
tablo(k) = feuilles(i)
End If
Next
'****************************
For j = 1 To UBound(tablo)
msg = msg & tablo(j) & vbCr
Next
MsgBox msg
'****************************
'Sheets(tablo).PrintOut
DoEvents
Unload Me
End Sub |
Partager