Can you put a loop inside an IF statement?

[Laurel]

HIIIIIIII!!!

I need to run through a chunk of code TWICE if a combo box text is LIKE <whatever>. If the combo box ISN'T LIKE <whatever>, I just need it to run once. Can you do this?

If cboNonHourlyDuties.Text Like "*CarSeal*" Then
    csString = "CAR SEALS INSPECTED"
    For indx = 0 To 1
End If

<Chunk of code>

If cboNonHourlyDuties.Text Like "*CarSeal*" Then
    csString = "CAR SEALS REHUNG"
    Next indx
End If

L

[Laurel]

The answer is NO! You can NOT do that! SO.....how do I do a loop under certain conditions?

[pclement]

Not sure if I understand your code but you can use a variable in the For statement in order to specify the number of times it should iterate:

For indx = 0 to NumIterations - 1

Next indx

[mstraf]

for indx = 0 to 1
<block of the loop>
if Not cmb... like "..." then exit for
next

Marco

[Laurel]

OH MARCO! You are such a big strong man!

You too, Paul!

L&K
L