Combo box with dynamic list using VBA

[hsejar]

Hi,
I'm relatively new at VBA programming in excel. hopefully someone could help.I have 2 fields in sheet1 supplier number and name , using them i have to go to sheet2 which has the list of suppliers and materials. from this list i have to select the list of materials associated to this supplier and show them in the combo box.

i'm attaching the file for reference.

thanks