Userform ComboBox to dinamically populate results basis of another combobox

[rlh]

On the attached example there is 2 command buttons. 1 - Archive and 2 - Correct. "Archive" populates userform1 that gives me the ability to enter specific information onto a worksheet into the last row of the spreadsheet. The UserForm1.ComboBoxes are Row Sourcing columns P-Q. This user form is working as needed. Often I need to make adjustments to these entries. So I have created a second user form to populate specific invitations to make changes.

"Correct" Command Button populates userform2. An invitation can have multiple commodities associated to it. So the combobox1 is sorting through column B and listing all the invitation number and because there is duplicates it is only showing the invitation numbers once. Again this is functioning as needed. Here is where I am looking for assistance...

I would like for UserForm2.ComboBox2 to only populate the commodities linked to the invitation number selected in UserForm2.ComboBox1. IE: if 12-1NMP-17-S-0016 is selected in ComboBox1 then I would only like Small Red, Split Yellow Pea, Whole Green Pea and Light red Kidney in ComboBox2. Once the user selects a commodity from ComboBox2 then code finds that particular row on the worksheet and populates: the Start Date, Offer Due Date, Shipping Period for Inland Plant, Shipping Period for Plants Located at the Port and Quantity in Metric Tons.

I am certain that I need a tie what is needed in ComboBox2 to a Change in ComboBox1, but not sure how to exactly attack it.

Thanks for any help available.


I was able to get this to work

Please Login or Register  to view this content.