1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
|
Private Sub UserForm_Initialize()
Dim LastLig1, LastLig2, LastLig3, LastLig4, LastLig5, LastLig6, LastLig7, LastLig8 As Long
Application.ScreenUpdating = False
Me.MultiPage1(0).Visible = True
Me.MultiPage1(1).Visible = False
Me.MultiPage1(2).Visible = False
Me.MultiPage1(3).Visible = False
Me.MultiPage1(4).Visible = False
Me.MultiPage1(5).Visible = False
LastLig1 = Sheets("Arch_Ville").Cells(Rows.Count, "F").End(xlUp).Row
LastLig2 = Sheets("Arch_CU").Cells(Rows.Count, "G").End(xlUp).Row
LastLig3 = Sheets("Arch_Bât").Cells(Rows.Count, "F").End(xlUp).Row
LastLig4 = Sheets("Arch_Bât").Cells(Rows.Count, "G").End(xlUp).Row
LastLig5 = Sheets("Général").Cells(Rows.Count, "F").End(xlUp).Row
LastLig6 = Sheets("Général").Cells(Rows.Count, "G").End(xlUp).Row
LastLig7 = Sheets("Arch_Dét").Cells(Rows.Count, "F").End(xlUp).Row
LastLig8 = Sheets("Arch_Dét").Cells(Rows.Count, "G").End(xlUp).Row
Me.ComboVille.RowSource = ("Arch_Ville!F4:F" & LastLig1)
Me.ComboCU.RowSource = ("Arch_CU!G4:G" & LastLig2)
Me.ComboBatVille.RowSource = ("Arch_Bât!F4:F" & LastLig3)
Me.ComboBatCU.RowSource = ("Arch_CU!G4:G" & LastLig4)
Me.ComboGenVille.RowSource = ("Général!F14:F" & LastLig5)
Me.ComboGenCU.RowSource = ("Général!G14:G" & LastLig6)
Me.ComboDetVille.RowSource = ("Arch_Dét!F4:F" & LastLig6)
Me.ComboDetCU.RowSource = ("Arch_Dét!G4:G" & LastLig7)
Application.ScreenUpdating = True
End Sub |
Partager