Visual Basic Course Online

Would you please give here detail about the Microsoft Visual Basic for Applications course offered by Virtual Training Academy ?

[Shaleen]

Microsoft Visual Basic for Applications (VBA) programming has a special format and syntax that must be followed in order for the computer to properly perform the work.

Microsoft Visual Basic for Applications (VBA) Course:

Duration:
7.5 hrs / 80 tutorials

Course Content:

Introduction
What VBA Is
What This Course Is About
VBA vs. Visual Basic
Using the VBA Editor
Data and Variables

Data Types
Storage and Data Sizes
Declaring Variables
Variable Names
Putting Values in Variables
Creating Constants
String Variables
Handy String Functions
What an Array Is
Creating Arrays

Resizing Arrays
2-Dimensional Arrays
Sample Variables
Using Macros

Macro Recording
Recording a Macro
Running a Macro
Editing a Macro
Help in VBA
Application Object
VBA Expressions

Simple Arithmetic Operators
Advanced Arithmetic Operators
Comparison Operators
Logical Operators
Order of Operations
Mathematical Expressions

Using Functions in Formulas
Mathematical Functions
Conversion Functions
String Functions
Finding Words in Strings
Replacing and Comparing Strings

Sample Expressions
Working with Dates
Date Functions
Dialog Boxes
User Interaction
Using Message Boxes

Format Options
Results of Message Boxes
Using Input Boxes
Functions and Procedures
Creating a Subroutine
Understanding Parameters

Parameter Passing
Function vs Procedure
Return Statement
Sample Function AVE
Arrays as Parameters
Conditional Processing

What Conditional Processing Is
IF Block
Complex Conditions
Nested IFs and Elseif
Using IF in Coin Toss

Sample Function MIN
Multiple Outcomes
SELECT Block
Multiple CASE Statements
Conditional Functions

Loops
Parts of a Loop
Infinite Loops
DO WHILE Loop
DO UNTIL Loop
FOR Loops
Running Arrays
Update AVE Function

Sample Array Sort
Sample Swap Routine
Tracing FOR Loops
Step Value in For Loops
EXIT Statement

Testing Your Work
The Debug Environment
Seeing Values
Stepping Through Code
Breakpoints
Finding and Fixing Errors

Conclusion
What We Learned
Planning for your VBA Code

Contact detail :
Virtual Training Company, Inc.
5395 Main Street
Stephens City, VA 22655
Sales: (408) 800 4130
Fax: (888) 316-5374
Sales: sales@vtc.com