VBA Userform: Use value from Comobox to populate a Listbox

1st of all let me say that over the past year or so I've found many answers to many questions about Excel browsing your forums. This site has been a tremendous help. Prior to 18 months ago I never touched Excel. In my mind it was nothing more than glorified app for making tables. However after taking a job as a PA with a company that is very "old school" in it's practices (I still have a stack of carbon copy order forms I use often) and after weighing several options & arriving at dead-ends, I realized Excel was my best option.

Less than a year ago I purchased the "purchase_order_manager" from Vertex42 for $15 and I've been on my way ever since. I've modified the thing to death & over time I've realized that there's so much more I could be doing and automating with Excel. For that reason I've begun working on my workbook for managing inventories & orders.

I've recently stumbled across a wonderful thing in VBA called "Userforms" which have opened a tremendous amount of possibilities with what I want to do. I'm very new to Excel let alone VBA. I know my around (enough to get into trouble) php code & some other languages & I'm typically pretty good at figuring things out however I've scoured forums, tutorials, videos & books for the past few days & I'm absolutely stuck....

What I'm working on... I have 2 worksheets in my workbook one named "Vendors" which is essentially a database of all the companies I buy materials from. The second sheet is called "Stock" which is a database of all the parts I buy from all vendors.


User Clicks "Create Order" button which brings up a form

User Selects "Vendor" form a combobox which has the RowSource property of "Vendors!VendorName" (VendorName is the name of the 1st column of that sheet)

When a vendor is selected in the combobox, the listbox below would populate with all the parts from the sheet "Stock" that belong to that vendor. User can then select or multiselect the parts to add to the order.

Clipboard02.jpgClipboard01.jpg

As you can see I can obviously get the parts listed in the listbox but I havent a clue how to display only ones by selected vendor. I really have no code thus far to share either.

Thanks in advance.

Worked like a charm! Thank you so much AlphaFrog