User form dependant comboboxes

[Vrhovni Bog]

Hi all,

I seem to got stuck with some vba code, that I am trying to adjust to my needs. I would appreciate some help

I found a tutorial for dependant comboboxes on this link: http://www.davesexcel.com/dependentcombobox.htm. This works perfectly, but I need some adjustments...

I am trying to do 2 things: First is to use data from sheet2 instead of sheet1 and the second to use comboboxes from simple user form that is launched by commandbutton instead of having two comboxes floating around.

The workbook should look like something like this:

Sheet1: Commandbutton> userform with combobox1 and combobox2
Sheet2: Database in two columns A (for the combobox1, ) and B (for the combobox 2 - dependant of the values in column A)

Column A will contain 4 sections, that will repeat (for example A,B,C,D and column B will contain some parts that will also repeat - Part 1, Part 2, Part 3, etc). So when I chose section A it should give me all parts in that section - Section A = Part 1, Part 3

Here's the file for further clarification:
Dependant ComboBox.xlsm

Thanks in advance for helping!

Regards,
Marko