List2 based on List1

**Hasnain** · 03-08-2008, 07:49 AM

Hi all

I want to create list2 based on list1 on vertical style. Refer Sheet 2. I have done the same thing in Horizontal Style on Sheet 1. Please see an attachment file.

Please help me at your earliest.

Thanks

**davesexcel** · 03-08-2008, 01:14 PM

Originally Posted by Hasnain

Hi all

I want to create list2 based on list1 on vertical style. Refer Sheet 2. I have done the same thing in Horizontal Style on Sheet 1. Please see an attachment file.

Please help me at your earliest.

Thanks

Hi,
Checkout this sample
http://www.excelforum.com/attachment...2&d=1177243070

**Hasnain** · 03-09-2008, 09:18 AM

Hi DEVESEXCEL,

Thank you so much for your link.

I have edited the code according to my will. But Still I have one problem. The problem is that When I select list from A1, the list in B1 to B5 does not refresh. I want to refresh the list 2 according to list 1. I think there is something wrong in my VB Coding. a file is attached for your ready reference.

Please check it. Thanks

**davesexcel** · 03-09-2008, 12:24 PM

Originally Posted by Hasnain

Hi DEVESEXCEL,

Thank you so much for your link.

I have edited the code according to my will. But Still I have one problem. The problem is that When I select list from A1, the list in B1 to B5 does not refresh. I want to refresh the list 2 according to list 1. I think there is something wrong in my VB Coding. a file is attached for your ready reference.

Please check it. Thanks

Maybe a slight change to the worksheet module

Please Login or Register  to view this content.

Then a slight change to the
DropDownAccordingToValue
macro

Please Login or Register  to view this content.

I am not sure what "=$X1" is,But this should give you an example to validate the range..

here's a quicker code to copy and paste

Please Login or Register  to view this content.

**Hasnain** · 03-10-2008, 03:45 AM

Hi DEVESEXCEL,

Thank you so much for your timely help.

Now dear I have made it on a VBA Userform. See an attached file. But I am not good in VBA Coding. I tried so hard to rectify the errors but I could not. Please check it the following bug which I have to rectify.

1) When I change ListBox1, other related Listboxes do not refresh.

2) Please find heading in ListBox1 & ListBox2 but Other Listboxes do not show the header.

3) I have defined Name of all ranges. How Can I use it on VBA Coding?

Please give me an early response.

Thanks