UserForm to select items from dependent lists

[JoePilot]

Hello all,

I am in need of your help concerning some coding. I will be most grateful for any help.

I have 3 dependent lists from which I want to select items and then paste these selections directly into a table. I considered 'Treeview' but came across a UserForm example (see credits below) and have started to modify the code for my needs.....but I am stuck !

I can best illustrate my problem by considering my data. I have 3 lists :

1. Car Make
2. Car Model
3. Engine Size.

I have a User Form that allows you to select the first item (Car Make). Once selected, the 2nd & 3rd dependent variables are shown : Car Model and Engine Size.

After the user has made a selection, I want to paste the details into next empty row in a table.

I have attached a file with some relevant data and this will help illustrate the above description.

I did not write all of the code, but the original source is

xbrlsite.com/DigitalFinancialReporting/Exemplars/2011-09-30/exemplars/ExemplarGrabber.zip

Thanks to the above for the examples.

Regards

Richard

[SamT]

Check this out. I haven't tested it.

I added lists to one sheet, Named those lists and used the list names as RowSources for the listboxes in the new UserForm.

[JoePilot]

Thanks SamT.. I'm still working on it !