How to implement continue and break at the same time in VBA

There is no continue and break in VBA, and the termination of the loop is implemented by exit do or exit for, for example:

1. for statement:

s=0for i=1 to 100

s=s+iif s>100 then

exit for 'Force exit the for loop.

end if

next i

2. do statement:

s=0do while true

s=s+iif s>100 then

exit do 'Force exit the do loop.

end if

loop

Yesterday's index was in the yang, and today it rose and fell as scheduled, and the final index closed at 3510 points with a doji. On the disk 2, the city of 70 ** daily limit, the new shares, restructuring and resumption of trading, quantum communication, bone conduction, etc. led the rise, the new shares needless to say that the new shares that have just been listed will definitely continue to rise and fall, and the other only part of the stagflation of the new shares has performed well, the momentum of the new shares has been greatly reduced, mainly because some of the new shares have been overhyped by the market has weakened recently, and it is expected to adjust for a period of time, and when the adjustment is in place, it will rise again, quantum communication is more active in the near future, and several ** consecutive 2-3 daily limits, Bone conduction is also up and down today, but I personally think that the sustainability will not be very strong, and finally the restructuring of the resumption of stocks, especially Zhongjiang Real Estate, Century Cruises continues to skyrocket to stimulate funds to speculate on this sector, and you can continue to focus on this sector in the later stage, technically, the main board index continues to focus on the gains and losses of 3540, only by standing firm can it change from weak to strong, otherwise the market will continue to adjust, the GEM index broke through 2720 points as scheduled, and the 2720 is expected to continue to expand upward, and the pressure point of the GEM market outlook, But it is still believed that it is a B wave, and there is still a possibility of C wave, which is a second wave of C adjustment, which we should be properly wary of, and it is expected that tomorrow is expected to continue to be the main one, whether the main board can break through 3540 to see the strength of brokerages and real estate, and the strategy is still based on ** operation.

Break and continue are in C, and in VB, they use ExitFor or ExitDo to jump out of the loop, similar to Break, and Continue can be implemented with if, or with a goto statement.

sub exits the loop early ().

dim i as integer

dim sum as integer

for i = 1 to 10

sum = sum + i

if sum > 20 then

exit for 'The condition is met to end the loop early

next i

msgbox "i=" & i & " sum= " & sumend sub

sub to make the next loop ahead of schedule ().

dim i as integer

dim arr

dim str as string

arr = array("Me", "Love", "You", "Medium", "country")

for i = 0 to 4

if i = 2 then

goto ignores the following statement ahead of the next one'Perform the later loop end if in advance

str = str & arr(i)

sum = sum + i

end sub

Implemented with goto, there is no built-in continue and break, but there is exit for and for each, just get used to it.

Continue and break cannot be used together. If you use it together, it won't work as well as it should. Because after the continue is executed, the statements after this line in the loop will not be executed in the current round of the loop.

If the break is executed, the whole cycle is ended.

Break and continue are in C, and in VB, they use ExitFor or ExitDo to jump out of the loop, similar to Break, and Continue can be implemented with if, or with a goto statement.

Here's how it is: in the inner loop, continue jumps out of the current loop, for example, the loop is 10 times, and when it is executed to the second time, it will not be executed this time, and it will jump to the third time to continue execution; If this is a break, all loops will pop up, that is, the rest of the loops will not be executed.

Got it. Hope understandable.

continue is to skip this loop, continue to the next time, break to abort the loop.

Break and continue are buried in C, VB uses exitfor or exitdo to jump out of the roll-off loop, liquid-like rent like break, continue can be implemented with if, or use goto statements.

Executed to continue means that the current loop is stopped immediately and the statement after continue is no longer executed, ending the "This Layer" loop and starting the next cycle immediately; When the break is executed, it will immediately jump out of the loop where the break is located, that is, the loop of "This Layer" will be ended.

continue: Terminates the current loop and goes directly to the next loop.

If normx<1e-6 is satisfied, the statements following continue will not be executed, and the next loop will be directly entered.

break is to jump out of the current loop.