Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Could I please have assistance with the code below, my aim is to compare
contents of ListBox2 with ListBox1 if a match is found to remove it from ListBox1; Dim i As Long, j As Long For i = 0 To ListBox2.ListCount - 1 DoEvents ListBox2.ListIndex = i For j = 0 To ListBox1.ListCount - 1 DoEvents ListBox1.ListIndex = j If InStr(1, ListBox2.List(ListBox2.ListIndex), ListBox1.List(ListBox1.ListIndex)) Then ListBox1.RemoveItem (j) End If Next j Next i End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare row contents | Excel Programming | |||
compare the contents of one range of cells with the contents of a. | Excel Discussion (Misc queries) | |||
COMPARE CELL CONTENTS | Excel Worksheet Functions | |||
compare cell contents | Excel Worksheet Functions | |||
How to compare the contents of two rows is the same? | Excel Programming |