United States Microsoft Visual Basic for Applications (VBA) Training
CD Contents For This Title
All the chapters and lesson contents of Microsoft Visual Basic for Applications (VBA) are listed below.
To help you evaluate our training, we have made some of the tutorials for Microsoft Visual Basic for Applications (VBA) freely available. Click on any of the linked lesson listings below to preview FREE!
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.
Choose your media type:
To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.
Hide This|
Introduction
|
||
| What VBA Is | (06:58) | |
| What This Course Is About | (07:21) | |
| VBA vs. Visual Basic | (05:46) | |
| Using the VBA Editor | (04:55) | |
|
Data and Variables
|
||
| Data Types | (05:56) | |
| Storage and Data Sizes | (06:51) | |
| Declaring Variables | (04:29) | |
| Variable Names | (05:09) | |
| Putting Values in Variables | (05:46) | |
| Creating Constants | (06:15) | |
| String Variables | (06:30) | |
| Handy String Functions | (07:43) | |
| What an Array Is | (05:29) | |
| Creating Arrays | (05:24) | |
| Resizing Arrays | (06:00) | |
| 2-Dimensional Arrays | (05:16) | |
| Sample Variables | (05:55) | |
|
Using Macros
|
||
| Macro Recording | (05:30) | |
| Recording a Macro | (04:51) | |
| Running a Macro | (03:33) | |
| Editing a Macro | (06:29) | |
| Help in VBA | (06:19) | |
| Application Object | (05:16) | |
|
VBA Expressions
|
||
| Simple Arithmetic Operators | (04:46) | |
| Advanced Arithmetic Operators | (04:39) | |
| Comparison Operators | (04:24) | |
| Logical Operators | (06:08) | |
| Order of Operations | (05:14) | |
| Mathematical Expressions | (08:09) | |
| Using Functions in Formulas | (06:28) | |
| Mathematical Functions | (04:11) | |
| Conversion Functions | (04:21) | |
| String Functions | (06:37) | |
| Finding Words in Strings | (07:56) | |
| Replacing and Comparing Strings | (06:33) | |
| Sample Expressions | (06:34) | |
| Working with Dates | (05:31) | |
| Date Functions | (06:49) | |
|
Dialog Boxes
|
||
| User Interaction | (05:55) | |
| Using Message Boxes | (06:10) | |
| Format Options | (07:14) | |
| Results of Message Boxes | (02:33) | |
| Using Input Boxes | (06:48) | |
|
Functions and Procedures
|
||
| Creating a Subroutine | (03:19) | |
| Understanding Parameters | (04:16) | |
| Parameter Passing | (05:06) | |
| Function vs Procedure | (04:40) | |
| Return Statement | (04:25) | |
| Sample Function AVE | (03:23) | |
| Arrays as Parameters | (03:30) | |
|
Conditional Processing
|
||
| What Conditional Processing Is | (03:54) | |
| IF Block | (06:21) | |
| Complex Conditions | (04:49) | |
| Nested IFs and Elseif | (06:02) | |
| Using IF in Coin Toss | (04:55) | |
| Sample Function MIN | (06:49) | |
| Multiple Outcomes | (05:42) | |
| SELECT Block | (04:53) | |
| Multiple CASE Statements | (05:24) | |
| Conditional Functions | (04:36) | |
|
Loops
|
||
| Parts of a Loop | (04:24) | |
| Infinite Loops | (04:14) | |
| DO WHILE Loop | (04:49) | |
| DO UNTIL Loop | (05:03) | |
| FOR Loops | (05:46) | |
| Running Arrays | (04:55) | |
| Update AVE Function | (07:38) | |
| Sample Array Sort | (06:34) | |
| Sample Swap Routine | (06:15) | |
| Tracing FOR Loops | (05:48) | |
| Step Value in For Loops | (06:35) | |
| EXIT Statement | (06:34) | |
|
Testing Your Work
|
||
| The Debug Environment | (05:10) | |
| Seeing Values | (05:01) | |
| Stepping Through Code | (06:05) | |
| Breakpoints | (06:20) | |
| Finding and Fixing Errors | (05:36) | |
|
Conclusion
|
||
| What We Learned | (04:05) | |
| Planning for your VBA Code | (03:54) | |
|
Credits
|
||
| About the Author | (05:13) | |
Email this Page
Send us FeedbackTitle Information / Pricing
| Title: | Microsoft Visual Basic for Applications (VBA) |
| Author: | Robert Ekblaw |
| SKU: | 34345 |
| ISBN: | 978-1-61866-050-3 |
| Release Date: | 2012-06-26 |
| Price: | |
| Duration: | 7.5 hrs / 80 lessons |
| Work Files: |
Yes |
| Captions: | Available on CD and Online University |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7 |
Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP NOW
LEARN MORE » Related Titles
Select Bandwidth
Now Shipping
Client Testimonials
You guys are great; your tutorials are outstanding. Thumbs up to Mark Bremmer for the Carrara 5 tutorials. He is an excellent teacher.
Todd Price