Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop within loop?
Hello,
I'm trying to fill a listbox with item in a range only if they are not in another range, I've tried to sort of get started with the code below, but it fails at the second test.I think i need a loop in a loop, but can't figure how to, could someone help please. Private Sub UserForm_Initialize() For Each Cell In Sheets("Sheet1").Range("A4:A12") With Me.ListBox1 If Cell.Value < "" And Cell.Value < Sheets("Sheet5").Range("B5:B10") Then .AddItem Cell.Value .List(.ListCount - 1, 1) = Cell.Offset(0, 1).Value .List(.ListCount - 1, 2) = Cell.Offset(0, 2).Value End If End With Next Cell End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
returning back to loop check condition without completing the loop | Excel Programming | |||
Loop to Filter, Name Sheets. If Blank, Exit Loop | Excel Programming | |||
(Complex) Loop within loop to create worksheets | Excel Programming | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Problem adding charts using Do-Loop Until loop | Excel Programming |