Private Sub UserForm_Initialize()
Poles = Application.Transpose(Range("Poles"))
Directions = Application.Transpose(Range("Directions"))
Services = Application.Transpose(Range("Services"))
' resultatTextBox = Application.Transpose(Range("resultatTextBox"))
Set D1 = CreateObject("Scripting.Dictionary")
For Each C In Directions: D1(C) = "": Next C
MultiPage1.Value = 0
Me.TextBox11.List = D1.keys
Me.TextBox24.List = D1.keys
' Remplir ICI la Table POLES et la liste
Set D2 = CreateObject("Scripting.Dictionary")
For Each C In Poles: D2(C) = "": Next C
TblPoles = D2.keys
Me.TextBox12.List = TblPoles
' Remplir ICI la Table SERVICES et la liste
Set D3 = CreateObject("Scripting.Dictionary")
For Each C In Services: D3(C) = "": Next C
TblServices = D3.keys
Me.TextBox13.List = TblServices
'
' Suite du code jusqu'à End sub