Tag Archives: Visual Basic for Applications

Visual Basic Mid sem Syllabus

Posted on by

Advantages of VBA:

  • An easy-to-use and versatile language
  • Integrated with off-the-shelf products
  • Minimizes development time and costs

Macros: The First Step:

  • Recording and executing macros
  • Limitations
  • Enhancing with VBA code

The Code Design and Debugging Tools:

  • Project Explorer
  • Help system
  • Code Window
  • IntelliSense
  • Properties Window
  • Object Browser
  • Block commenting and uncomment
  • Code stepping
  • Immediate Window
  • Breakpoints

Putting Objects to Work:

 

Storing Data In Variables:

  • How and when to declare variables
  • Selecting data types
  • Fixed and dynamic arrays
  • Constants
  • The scope and lifetime of variables

Conditional Branching:

  • If…Then…Else
  • Select…Case

Looping Through Code:

  • Do…Loop, While and Until
  • For…Next and For Each…Next

Building Procedures:

  • Creating Sub and Function procedures
  • Calling procedures
  • Passing arguments to procedures

Using Intrinsic Dialogs:

  • Communicating with the user through the message box
  • Gathering user information with the input box
  • Utilizing the File Dialog object and Dialogs collection

Handling Runtime Errors:

  • The On Error GoTo structure
  • Classifying errors with the Err object
  • Continuing execution with Resume, Resume Next or Resume label