Search Results for Microsoft Office Training Tutorials
This tutorial teaches you how to use the While Loop, including a detailed explanation of the While Loop syntax. This type of loop is sometimes referred to as the While Wend Loop and is the most basic type of loop in VBA. This is a step by step introduction to the usage of this loop and, in addition, the comparison operators that are used in loops. After watching this tutorial, you will be able to make your own While Loops in VBA.
| Tutorial Length (mm:ss): |
8:51 |
| Microsoft Office Program: |
Microsoft Office Excel |
This tutorial shows you how to exit out of a Do Loop in VBA. You will learn how to manually cancel or stop a loop or macro from running once it has started and also how to include code within the loop that will prevent the loop from running infinitely by exiting or stopping the loop.
| Tutorial Length (mm:ss): |
5:06 |
| Microsoft Office Program: |
Microsoft Office Excel |
This is a comparison of the Do Until and the Do While loops in VBA. This tutorial will illustrate the similarities and differences between these two types of loops and will help you understand which loop type might be better for you.
| Tutorial Length (mm:ss): |
6:37 |
| Microsoft Office Program: |
Microsoft Office Excel |
This tutorial shows you how to use a Do Until Loop in VBA and Macros. There are two basic types of Do Until Loops – one where the condition is checked at the beginning of the loop and another where the condition is checked at the end of the loop – and this tutorial covers both of these types of loops. After viewing this tutorial, you will know how to make a Do Until Loop.
| Tutorial Length (mm:ss): |
11:11 |
| Microsoft Office Program: |
Microsoft Office Excel |
This tutorial shows you how to use a Do While Loop in VBA and Macros. The Do While Loop is one of the most widely used loops in VBA and Excel and is relatively easy to understand and use. There are two basic types of Do While Loops – one where the condition is checked at the beginning of the loop and another where the condition is checked at the end of the loop – and this tutorial covers both of these types of loops. You will know how to make your own Do While Loops after viewing this tutorial.
| Tutorial Length (mm:ss): |
10:00 |
| Microsoft Office Program: |
Microsoft Office Excel |
This Excel VBA macro tutorial shows you how to quickly add elements to a dynamic array using a loop. The loop used for this example is a For Next Loop. This tutorial covers how to use variables instead of hard coded values to resize a dynamic array and then to add a new element to the array.
| Tutorial Length (mm:ss): |
8:16 |
| Microsoft Office Program: |
Microsoft Office Excel |
This Excel VBA macro tutorial shows you how to loop through the elements contained within a dynamic array variable in VBA. This tutorial will show you how to use a For Next Loop in order to access each of the elements within a dynamic array. This is a little tricky with a dynamic array because you need to dynamically reference the upper and lower bounds of the array variable. This tutorial is a must view for anyone who works with dynamic arrays in VBA.
| Tutorial Length (mm:ss): |
8:52 |
| Microsoft Office Program: |
Microsoft Office Excel |
This Excel VBA macro tutorial shows you how to loop through a static array variable in VBA. This tutorial will show you how to use a For Next Loop in order to quickly add elements or items to an array variable and also to quickly retrieve or get elements from a static array variable. This technique is very useful and will help you streamline your VBA code.
| Tutorial Length (mm:ss): |
8:23 |
| Microsoft Office Program: |
Microsoft Office Excel |
This Excel VBA macro tutorial shows you how to add multiple worksheets, sheets, tabs, etc. to a workbook using a macro. This method does not use a loop and so is very easy to use and understand. As well, you will learn how to insert the new sheets before or after other sheets within the workbook.
| Tutorial Length (mm:ss): |
7:46 |
| Microsoft Office Program: |
Microsoft Office Excel |
This Excel VBA macro tutorial shows you how to find the first and last index number of an array variable. These index numbers are also referred to as the lower and upper bounds of an array variable. This information is very helpful when trying to loop through an array or access its contents.
| Tutorial Length (mm:ss): |
4:49 |
| Microsoft Office Program: |
Microsoft Office Excel |
This Excel VBA macro tutorial shows you how to determine the number of items or elements contained within an array variable. This is very important when you want to loop through an array variable. Note, this is not necessarily the same as the upper bound or last index number of an array variable and it can take some extra work, which is covered in this tutorial, to determine exactly how many elements are contained within an array variable.
| Tutorial Length (mm:ss): |
9:11 |
| Microsoft Office Program: |
Microsoft Office Excel |
