Update Linked ComboBox List Based On Change In Another ComboBox Selection

[paul_pearson]

The code is for a userform.I need some help with adding code.In the userform if Internal (combobox3) is selected then I want Combobox`s 5 & 4 & 6 to have a certain list to choose from.The lists would be for Part,Part No. and Fault for Internal.If In the userform External (combobox3) is selected then Combobox`s 5 & 4 & 6 will have a different list to choose from.The lists would be for Part,Part No. and Fault for External..I would prefer this to be hard coded but if it needs to be called from a sheet then that will also do

The lists are a example in sheet called Sample...

At present the combobox 5 & 4 & 6 just have zero`s as entries for now until I work out how to code

Thanks