Populate Combobox With An If Statement?

[gxm100]

In the attached workbook, I have come up with a condensed version of something I am working on in a larger project. Essentially, there is one table "Orders" on Sheet1, and there is one userform. On the userform - OrderID will be a set field - in this example I have it set to a value of 100. I would like the Product combobox to populate with options which relate only to OrderID 100 in the Orders table - nails and screws.

The ultimate idea is that whatever OrderID is entered, will "filter" the combobox dropdown to only products relating to that OrderID.

I don't know if maybe an If statement is what I need to make this work?

If anyone is able to help I would greatly appreciate the time and effort

Best!

[Arkadi]

If the value of the orderID textbox is static then:

Please Login or Register  to view this content.

If the user will be changing the orderID value, then you might be better off putting it in the afterupdate event for the orderID textbox.

[gxm100]

Thanks Arkadi - works perfectly!