Svmaxcel
10-04-2017, 12:49 PM
I created 3 combo box to list the items.
Created Name Range as Item1,Item2,Item3.
Used code on userform initialize to load row source as Item1.
Userform.Initialize
Item1.rowsource = "Item1"
When I run the form, I am able to see all items listed in Item1.
But the items are duplicated.
Example :
Laptop appears 5 to 6 times and same with desktop.
I want it to be displayed only once.
Also wanted to link Item2 and Item3 based on Selection.
In short, depended combo box as per the condition.
Please let me know how to remove duplicate and create dependent list.
File attached.
Created Name Range as Item1,Item2,Item3.
Used code on userform initialize to load row source as Item1.
Userform.Initialize
Item1.rowsource = "Item1"
When I run the form, I am able to see all items listed in Item1.
But the items are duplicated.
Example :
Laptop appears 5 to 6 times and same with desktop.
I want it to be displayed only once.
Also wanted to link Item2 and Item3 based on Selection.
In short, depended combo box as per the condition.
Please let me know how to remove duplicate and create dependent list.
File attached.