Creating Price Quote With Userform That Contains Cascading Drop-Down Lists

        In this study, we created a userform that automatically displayed to make it easier to enter data into the worksheet. The userform contains dependent combo boxes( combobox in which the list depends on the selection made in another combobox),textbox and button.

The Scripting Dictionary Object was used to fill in combo boxes :

Dim SD As Object

Set SD = CreateObject(“Scripting.Dictionary”)
For Each x In Supplier
SD(x) = “”
Next x
ComboBox1.List = SD.keys

…