Sub test()
Call GetCombo_Projet(ThisWorkbook.Sheets("Accueil").ComboProjet)
End Sub
Sub GetCombo_Projet(ByVal ComboDest As Control)
Dim CptrLig As Long
ComboDest.Clear
Call Get_DATA_PROJET(DATA_PROJET.NUM)
ReDim VarGlobale(LBound(Tbl_PROJET) To UBound(Tbl_PROJET), 1 To 2)
For CptrLig = LBound(Tbl_PROJET, 1) To UBound(Tbl_PROJET, 1)
VarGlobale(CptrLig, 1) = Tbl_PROJET(CptrLig, DATA_PROJET.NUM)
VarGlobale(CptrLig, 2) = Tbl_PROJET(CptrLig, DATA_PROJET.NUM) & " - " & Tbl_PROJET(CptrLig, DATA_PROJET.iNTIT)
Next
ComboDest.Object.List = VarGlobale
End Sub