Intellisense

IntelliSense is Microsoft’s implementation of autocompletion, best known for its use in the Microsoft Visual Studio integrated development environment. In addition to completing the symbol names the programmer is typing, IntelliSense serves as documentation and disambiguation for variable names, functions and methods using reflection.

Continue reading

Visual Basic Mid sem Syllabus

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