que ma lite vue m'affiche que ce mois avec les donnees a suivre qui vont bien.
que ma listview
ne m'affiche que ce mois avec les données correspondant à ce mois.
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionFor Each V In Range("a4:a" & Range("a65536").End(xlUp).Row)
For i = 1 To 12 ComboBox1.AddItem MonthName(i) Next
Private Sub ComboBox1_Click() mois_choisi = ComboBox1.Text End Sub
If V.text = mois_choisi then ... tes ajouts end if
Private Sub ComboBox1_Click() mois_choisi = ComboBox1.Text End Sub
Private Sub CommandButton1_Click() Me.Hide Sheets("Massage").Select End Sub Private Sub Massage_Click() Load Resa_Massage Resa_Massage.Show Unload UserForm8 UserForm8.Show Sheets("Menu").Select End Sub Private Sub Retour_Menu_Click() Sheets("Menu").Select Unload UserForm8 End Sub Private Sub TextBox1_Change() Me.TextBox1 = Sheets("Massage").Range("J2") End Sub Private Sub ComboBox1_Click() mois_choisi = ComboBox1.Text End Sub Private Sub userform_Activate() Sheets("Massage").Select Application.DisplayFullScreen = True TextBox1.Value = Sheets("Massage").Range("J2").Value With Resa_Massage .StartUpPosition = 3 .Width = Application.Width .Height = Application.Height .Left = 0 .Top = 0 End With 'Suppression des titres de colonnes ListView9.ColumnHeaders.Clear 'Alimentation des titres de colonne : ListView9.ColumnHeaders.Add , , "Mois", ListView9.Width * 0.1, lvwColumnLeft ListView9.ColumnHeaders.Add , , "Nom", ListView9.Width * 0.17, lvwColumnLeft ListView9.ColumnHeaders.Add , , "Nº MH", ListView9.Width * 0.06, lvwColumnCenter ListView9.ColumnHeaders.Add , , "Date", ListView9.Width * 0.1, lvwColumnCenter ListView9.ColumnHeaders.Add , , "Type de Massage", ListView9.Width * 0.2, lvwColumnCenter ListView9.ColumnHeaders.Add , , "Réglement", ListView9.Width * 0.12, lvwColumnCenter ListView9.ColumnHeaders.Add , , "Durée", ListView9.Width * 0.1, lvwColumnCenter ListView9.ColumnHeaders.Add , , "Prix", ListView9.Width * 0.06, lvwColumnCenter ListView9.ColumnHeaders.Add , , "Total", ListView9.Width * 0.09, lvwColumnCenter 'on remplit la listview With Me.ListView9 .ListItems.Clear If V.Text = mois_choisi Then 'For Each V In Range("a4:a" & Range("a65536").End(xlUp).Row) x = x + 1 .ListItems.Add , , V.Text .ListItems(x).ForeColor = V.Font.Color For j = 1 To 8 .ListItems(x).ListSubItems.Add , , V.Offset(0, j).Text .ListItems(x).ListSubItems(j).ForeColor = V.Offset(0, j).Font.Color Next j 'Next V End If End With End Sub
Private Sub userform_Activate()