JoePilot
05-07-2013, 01:38 AM
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
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