Being a beginner at VBA I find this REALLY hard to tackle. Hope any of you could help me out!

Here's my goal:
To have a userform with 4 listboxes that writes a selection from the listboxes onto MS word.

- Listbox1 selects the first hiarchy: A, B or C

- Listbox2 is the second hiarchy. It loads data from an external excel file, depending on the choice in Listbox1. To find what data to populate the Listbox2 with, a search in column B is necessary. In column B is listed: A1 to A100 and B1 to B50 and C1 to C20. So to find out what part of column F to populate in Listbox2 it must search in column B to find the right range.

- Listbox3 is a selection of column A depending on the selection in Listbox2(or column F)

- Listbox4 show the selected items from listbox3 (This works fine already)

- CommandButton3 has the contents of Listbox4 put in the Word document (This works fine already)

I have everything set up, but am still looking for a clever way to:
1. read and search for the right contents in the dependable listboxes and populate them.
2. make the listboxes dependable.

Here's my code so far:
Please Login or Register  to view this content.
As you can see, I have been trying to populate Listbox1. The other listboxes are still populated by hand and not dependant(but they should be).

I have created a button in the Word document toolbar to load the userform using this code in a module:
Please Login or Register  to view this content.



I believe I am on the right road but this stuff is making my head spin. Please help or advise!
Thanks in advance!