
Microsoft Visual Basic for Applications (VBA)
The Microsoft Office suite of applications (Word, Excel, PowerPoint, and Access) allows users to customize views or output, but the processing performed by the applications cannot be changed. However, Microsoft provides an interface in which the user can create customized processing. The language used for this customized processing is based on a computer programming language called Visual Basic. The Microsoft programming environment, called Visual Basic for Applications, has a special format and syntax that must be followed in order for the computer to properly perform the work. This VTC course describes the reserved keywords, structures, and language aspects that a user would need to know in order to create customized processing for Microsoft Office applications. Work Files are included. To begin learning today, simply click on the movie links.
Course content
Introduction4 lessons
Data and Variables13 lessons
- Data Types5:561 credit or ad
- Storage and Data Sizes6:511 credit or ad
- Declaring Variables4:291 credit or ad
- Variable Names5:091 credit or ad
- Putting Values in Variables5:461 credit or ad
- Creating Constants6:151 credit or ad
- String Variables6:301 credit or ad
- Handy String Functions7:431 credit or ad
- What an Array Is5:291 credit or ad
- Creating Arrays5:241 credit or ad
- Resizing Arrays6:001 credit or ad
- 2-Dimensional Arrays5:161 credit or ad
- Sample Variables5:551 credit or ad
Using Macros6 lessons
VBA Expressions15 lessons
- Simple Arithmetic Operators4:461 credit or ad
- Advanced Arithmetic Operators4:391 credit or ad
- Comparison Operators4:241 credit or ad
- Logical Operators6:081 credit or ad
- Order of Operations5:141 credit or ad
- Mathematical Expressions8:091 credit or ad
- Using Functions in Formulas6:281 credit or ad
- Mathematical Functions4:111 credit or ad
- Conversion Functions4:211 credit or ad
- String Functions6:371 credit or ad
- Finding Words in Strings7:561 credit or ad
- Replacing and Comparing Strings6:331 credit or ad
- Sample Expressions6:341 credit or ad
- Working with Dates5:311 credit or ad
- Date Functions6:491 credit or ad
Dialog Boxes5 lessons
Functions and Procedures7 lessons
Conditional Processing10 lessons
- What Conditional Processing Is3:541 credit or ad
- IF Block6:211 credit or ad
- Complex Conditions4:491 credit or ad
- Nested IFs and Elseif6:021 credit or ad
- Using IF in Coin Toss4:551 credit or ad
- Sample Function MIN6:491 credit or ad
- Multiple Outcomes5:421 credit or ad
- SELECT Block4:531 credit or ad
- Multiple CASE Statements5:241 credit or ad
- Conditional Functions4:361 credit or ad
Loops12 lessons
- Parts of a Loop4:241 credit or ad
- Infinite Loops4:141 credit or ad
- DO WHILE Loop4:491 credit or ad
- DO UNTIL Loop5:031 credit or ad
- FOR Loops5:461 credit or ad
- Running Arrays4:551 credit or ad
- Update AVE Function7:381 credit or ad
- Sample Array Sort6:341 credit or ad
- Sample Swap Routine6:151 credit or ad
- Tracing FOR Loops5:481 credit or ad
- Step Value in For Loops6:351 credit or ad
- EXIT Statement6:341 credit or ad