Cascading Comboboxes with using worksheet name to populate first combobox

[maestrodrex]

Hi guys,

I am pretty much a newbie in vba but very much interested in its capabilities. for this i have a form with 5 comboboxes and a listbox.

So here is my problem. I have a sample file here where i have multiple worksheets (in this sample i only put 2 but i have about 20 on my actual data) and i want to populate my first combobox to be populated by each worksheet name. (i guess this one is simple enough for some of the people here)

so here's where things get tricky, based on the selection on the first combobox, it will populate the 2nd the unique values of the first column (some are duplicating) which value will in turn populate the 3rd combobox with the unique values of the second column that is related on the first column and so on and so forth. after i picked all of the values, the listbox shows the min qty, max qty, remaining qty and updated by of that specific item

Note:these values are not on the same location in each worksheet.

so the scenario looks like this:

combobox1: list is resistor and capacitor
*i picked resistor

combobox2: list are the unique values of the 1st column
*i picked 1R

combobox3: shows 0.25, 0.5, 0.6, 1, 2, 2.5
*i picked 0.25

combobox4: shows 1, 5
*i picked 1

listbox shows: min qty 15, max qty 50, remaining qty 1, updated by jerome

attached is a sample of my database.
hope this is not too much for our forum members here. Thank you so much for your help.

Loadboard Sample Inventory.xlsm

[LJMetzger]

Hi maestrodrex and welcome to ExcelForum,

Try the attached file which should get you started. In the 'Control' Sheet, 'Left Click' the Square Yellow Shape that says 'Display UserForm'. The file was zipped to make it smaller.

Lewis