Private Sub Cbx_DropButtonClick()
Dim Target As Range, Zone As Range, TCible(), LC As Long, TSource(), LS As Long
Set Target = Union([Tableau1[Nom]], [Tableau2[Nom]], [Tableau3[Nom]], [Tableau4[Nom]])
For Each Zone In Target.Areas: LC = LC + Zone.Rows.Count: Next Zone
ReDim TCible(1 To LC, 1 To 1): LC = 0
For Each Zone In Target.Areas
TSource = Zone.Value
For LS = 1 To UBound(TSource, 1)
LC = LC + 1: TCible(LC, 1) = TSource(LS, 1)
Next LS, Zone
Cbx.List = TCible
End Sub