Dear Forum,
Is it possible to perform multiple (nested?) loops in one.
For example:
Thing is, I have three sets of data I want to consider and a couple of single lookups.
So I have for example:
for i =1 to 5
for i = 11 to 16
for i =21 to 24
and i = 36 and i = 42
Is it possible to perform all these loops in one?
Thank you,
Rudy
Is it possible to perform multiple (nested?) loops in one.
For example:
Code:
For Each ctl In Me.Controls
For i = 1 To 5
If ctl.ControlType = 106 Then
With ctl.Controls(0)
If ctl Then
If ctl.Name = "P" & i Then
'my stuff... Dlookup something in table
End If
End If
End With
End If
Next i
Next ctl
So I have for example:
for i =1 to 5
for i = 11 to 16
for i =21 to 24
and i = 36 and i = 42
Is it possible to perform all these loops in one?
Thank you,
Rudy