Hi all,

I succeeded to create a userfom in which I create comboboxes each time I click on command buttom.
My troubles are with the fact that when I choose a value in the first combobox, I want that choice do not display within the new comboboxes that will be created later.
I attached a copy of the file.
Thank in advance.

Private Sub CommandButton1_Click()

Dim ctlCombo As MSForms.ComboBox
Dim lngCounter As Long
Set F = Sheets("Settings")
Set Liste = CreateObject("Scripting.Dictionary")
For Each C In F.Range("MarketList").Value
Liste(C) = ""

lngCounter = J1U.Value ' JU.Value JU is a textbox tale a value 1 when userfom is being lauch
lngCounter = lngCounter + 1

Set ctlCombo = Me.Controls.Add("Forms.ComboBox.1", "JComboBox" & lngCounter)

ctlCombo.Left = 30
ctlCombo.Top = 126 + lngCounter * 20
ctlCombo.Height = 15.75
ctlCombo.Width = 156
J1U.Value = lngCounter

Me("JComboBox" & lngCounter).List = Liste.Keys
End Sub

Private Sub UserForm_Initialize()

J1U.Value = 1

End Sub