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 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,Originally Posted by Hasnain
Checkout this sample
http://www.excelforum.com/attachment...2&d=1177243070
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 moduleOriginally Posted by Hasnain
Then a slight change to thePlease Login or Register to view this content.
DropDownAccordingToValue
macro
I am not sure what "=$X1" is,But this should give you an example to validate the range..Please Login or Register to view this content.
here's a quicker code to copy and pastePlease Login or Register to view this content.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks