Hi all hope someone can help
I have a userform, that contains a 2 combo boxes, the first I want to use for "Suppliers Name" The second I would like the source for this to be determined by what is in combobox 1
Example.. if combobox 1 has FRED in it, then combobox 2 will only have options for what FRED sells, ditto if Combobox has Ben in it then Combobox 2 will have only have options for what BEN sells.
In the spreadsheet I have the formulas to achieve this, nut unsure how if possible this can be done in a userform
Your help appreicated
I have a userform, that contains a 2 combo boxes, the first I want to use for "Suppliers Name" The second I would like the source for this to be determined by what is in combobox 1
Example.. if combobox 1 has FRED in it, then combobox 2 will only have options for what FRED sells, ditto if Combobox has Ben in it then Combobox 2 will have only have options for what BEN sells.
In the spreadsheet I have the formulas to achieve this, nut unsure how if possible this can be done in a userform
Your help appreicated