Dependent Combo Boxes

Dear All,

I am learning VBA macros, I need help with the following-

I have made a VBA form for inventory list, where in one Combo holds the list of Raw Materials. I need to populate value in another combo box which will show vendors. The second combo box will be dependent on the name of Raw Material in the first combo box. The idea is that one Raw Material can be purchased from multiple vendors. Please note that there is a Text Box involved that will reflect the price, which is dependent on the Raw Material and Vendor Name.

Request some guidance.

Hi and welcome

This is easy enough to do, but would be easier if we could see your form and where the data for the comboboxes is coming from.

Could you attach a sample workbook?

BSB

Thank you so much

Attachment 838899 RM File

Attachment 838900 Inventory Form

Hopefully you can see this

Can't open the attachments. Follow the instructions in the yeloow banner at the top of the page.

BSB.

Created a excel sheet with the details and attached it.
Hope you can view this.

Got it! Apologies trying to get a hang of this. Attaching the file. It might seem a bit haphazard. Like I said I am very new at this, been googling and learning.

I'm confused... Not sure where the dependent controls are with so little information provided.

Happy to leave this one to you @torachan. Good luck mate

BSB

If you could please check the RM_INPUT sheet, the point is if you choose an RM, there will be a choice of vendors and once you choose the vendor the appropriate rate will show. The gist of the matter is one can buy same Raw Material from multiple Vendor at multiple price. Does that help?

I have enclosed a sample book that shows you how to do this, so you can see my method
If this is what you are looking for you can use this method in your Workbook.

Sample Workbook DependantCombos.xlsm