Statements Used in Looping and Decision Making
 
Task               Statement            Action
 
Looping            FOR...NEXT        Repeats statements between FOR and
                                     NEXT a specific number of times
 
                   EXIT FOR          Provides an alternative way to
                                     exit a FOR...NEXT loop
 
                   DO...LOOP         Repeats statements between DO and
                                     LOOP, either until a given condition
                                     is true (DO...LOOP UNTIL condition),
                                     or while a given condition is true
                                     (DO...LOOP WHILE condition)
 
                   EXIT DO           Provides an alternative way to exit
                                     a DO...LOOP loop
 
                   WHILE...WEND      Repeats statements between WHILE and
                                     WEND while a given condition is true
                                     (similar to DO WHILE condition...LOOP)
 
Making decisions   IF...THEN...ELSE  Conditionally executes or branches to
                                     different statements
 
                   SELECT CASE       Conditionally executes different
                                     statements