+ Reply to Thread
Results 1 to 5 of 5

List2 based on List1

  1. #1
    Registered User
    Join Date
    03-02-2008
    Posts
    7

    List2 based on List1

    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
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,238
    Quote 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

  3. #3
    Registered User
    Join Date
    03-02-2008
    Posts
    7

    List2 Refresh problem

    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
    Attached Files Attached Files

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,238
    Quote 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.

  5. #5
    Registered User
    Join Date
    03-02-2008
    Posts
    7

    List2 Refresh problem - USERFORM

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1