Introduction
Excel Application
Control Flow - Statements
Wkb Add-in Attendance
Forms with Excel

 

 

 

 

 

    If Statement

     

     

  • Expression returns BOOLEAN value i.e True\False

    •  

  • If expression is TRUE it executes the STATEMENT

    •  

    Do Loops

     

  • We can Classify the Do Loops in Two ways

    •  

    Classification of DO Loops with respect to testing of Loop determinant

     

  • (i)Do While (ii) Do Until

    •  

    Do While:

  • Do while iterates when condition is TRUE

    •  

  • We can place the condition or expression at the of Iteration

    •  

    Do Until:

  • Do Until iterates until condition is TRUE
  • We can place the condition or expression at the of Iteration

    •  

  • Exit DoEnables the appliation to EXIT from the Loop and when criteria met

    •  

    For Loop

     

  • We can Classify For Loop in (i)For .... Next (ii) For Each ... Next

    •  

     

     

     

    Goto

     

    Goto MoveFromHere
    MoveFromHere:

     

    Exit Sub

     

  • SUBROUTIES termed as SUB
  • It enables the user to complete a procedure
  • We can exit the sub with the help os EXIT SUB

    •  

Welcome to VB.Net Tutorial