Page 2 of 2 FirstFirst 1 2
Results 11 to 13 of 13

Thread: Remove Duplicates between two Dynamic Listboxes

  1. #11


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Please Press Filter control button on the "Main Controls" sheet>then go to Filters Tab> All Filters> and in the text box there enter anything and the error will come up

    Edit: The point that i want to achieve is that when there is something in the right list box and it tries to filter in the left list box, it would just filter the ones out that already exist in the right
    Last edited by JustLukas; 2014-06-11 at 12:27 PM.

  2. #12
    Conjurer snb's Avatar
    Join Date
    May 2013
    Posts
    376
    Articles
    0
    Excel Version
    2020
    Code:
    Sub M_snb()
        sn = lsb1.List
        sp = lsb2.List
        
        For j = 0 To UBound(sn)
          If IsError(Application.Match(sn(j, 1), sp, 0)) Then c00 = c00 & "_" & j + 1
        Next
        
        lsb1.List = Application.Index(sn, Split(Mid(c00, 2), "_"), 0)
    End Sub

  3. #13
    I modified it a bit and it works! Thanks Snb! Interesting way of doing it!

Page 2 of 2 FirstFirst 1 2

Posting Permissions

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