excel - 如何在 Excel VBA 中退出 1 个以上的 for 循环？

Question

代码如下:

'first for loop
for I = 1 to 5 
    do sth
    'second for loop
    for j = 2 to 7
        do sth
        'third for loop
        for m = 2 to 43
            if [condition] then 
               exit 2nd and 3rd loop and continue on next I ?????
            end if
        next
    next
next

我写了两个 Exit For ，但它没有帮助。它只退出了第三个 for 循环并继续下一个 j。

Answer 1

如果在循环中嵌套一个标志，则可以在循环第二个循环之前放置一个 if 语句。如果标志为真，那么您也退出第二个循环。

'first for loop
for I = 1 to 5 
    do sth
    'second for loop
    for j = 2 to 7
        do sth
        'third for loop
        for m = 2 to 43
            if [condition] then 
               flg = True
               Exit for
            end if
        next
    If flg = True then Exit For
    next
next