Search Results for Microsoft Office Training Tutorials
This Excel VBA macro tutorial shows you how to create a dynamic array variable in vba and macros. This tutorial covers how to declare a dynamic array; how to size a dynamic array; how to resize a dynamic array; how to input and output values from an array variable; and how to add values or elements to an array variable without deleting previously stored elements within the array. This is a comprehensive overview and explanation of dynamic arrays in vba and macros.
| Tutorial Length (mm:ss): |
19:36 |
| Microsoft Office Program: |
Microsoft Office Excel |
This Excel VBA macro tutorial shows you how to increase and decrease the size of a dynamic array variable in VBA. This is the same as increasing or decreasing the index number or lower and upper bounds of a dynamic array and will allow you to put more elements into a dynamic array. This is the feature of a dynamic array that actually makes it dynamic.
| Tutorial Length (mm:ss): |
6:30 |
| 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 two different ways to clear or delete all of the values from a dynamic array in VBA. This is a very important thing to know how to do with dynamic arrays because it will allow you to free memory that your macro or program is using. One of the methods in this tutorial will allow you to retain the array’s size while the other one will completely remove or delete the array’s size along with the data contained within the array variable.
| Tutorial Length (mm:ss): |
5:35 |
| 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 add elements to a dynamic array variable in VBA. This tutorial will also cover how to prevent previous elements in the array from being erased when you add a new element to the array. This is especially important when you need to increase the size of the array in order to add an extra element or multiple new elements to the array, which is also covered in this tutorial.
| Tutorial Length (mm:ss): |
5:45 |
| Microsoft Office Program: |
Microsoft Office Excel |
This Excel VBA macro tutorial shows you how to check if a variable is an array variable or a regular variable in VBA. This method works the same for static and dynamic array variables.
| Tutorial Length (mm:ss): |
3:14 |
| Microsoft Office Program: |
Microsoft Office Excel |
This Excel VBA macro tutorial shows you how to set or declare the lower bound or first index number of an array in VBA. You will learn how to control the number for the lower bound of an array variable and how to set this for specific arrays as well as for all of the arrays within a macro.
| Tutorial Length (mm:ss): |
7:32 |
| Microsoft Office Program: |
Microsoft Office Excel |
This Excel VBA macro tutorial shows you how to convert a string of words into an array in VBA. This will allow you break words or phrases up into individual elements within an array variable. Putting this type of data into an array will allow you to make more versatile and powerful macros.
| Tutorial Length (mm:ss): |
7:31 |
| Microsoft Office Program: |
Microsoft Office Excel |
This Excel VBA macro tutorial shows you how to create a static array variable in VBA. You will learn how to create or declare an array as well as to fill or populate or insert values into an array variable and then access the values contained within the array. This tutorial focuses on a static array variable. That means that the variable’s size cannot be changed after declaration.
| Tutorial Length (mm:ss): |
9:32 |
| 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 convert an array variable into a regular string of words. This basically allows you to change an array variable into a regular variable in VBA. Also, using this method, you can specify what will separate the elements of the array once they are in a normal variable. This is a must view tutorial for those who work with strings and arrays in VBA.
| Tutorial Length (mm:ss): |
6:01 |
| 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 |
This Excel VBA macro tutorial shows you how to store or insert values into an array in VBA. This tutorial covers the basics of putting values into an array for later retrieval. This is one of the very basic things that you must do with an array.
| Tutorial Length (mm:ss): |
3:47 |
| Microsoft Office Program: |
Microsoft Office Excel |
This Excel VBA macro tutorial shows you how to get or retrieve or output values from an array in VBA. This tutorial covers the basics of getting values out of an array for use within the macro and VBA. This is a great tutorial for those just starting out with arrays in macros.
| Tutorial Length (mm:ss): |
4:15 |
| 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 clear or erase all of the items contained within a static array variable. This means that all text strings will be turned into empty strings and all numbers will be turned into zeros. However, this method will not change or alter the size of the static array.
| Tutorial Length (mm:ss): |
5:50 |
| Microsoft Office Program: |
Microsoft Office Excel |
This Excel VBA macro tutorial explains arrays. This tutorial explains the difference between a regular variable and an array variable in VBA.
| Tutorial Length (mm:ss): |
2:17 |
| Microsoft Office Program: |
Microsoft Office Excel |
Learn how to change a static table of data in Excel 2007 into a dynamic and professional looking table using the Format as Table feature in Excel 2007. This tutorial is an introduction to using the Format as Table feature and does not cover all of the possible benefits of this feature in depth.
Using this feature allows you to quickly add new rows to the table that are already formatted to fit the table; add a Total Row to the table in order to perform quick calculations in the data; quickly change the entire format, look, and feel of the table; perform sorting and filtering on the table; and much more.
| Tutorial Length (mm:ss): |
7:57 |
| Microsoft Office Program: |
Microsoft Office Excel |
This tutorial shows you the keyboard shortcut for copying and pasting values in Excel. This will allow you to take any formula or function and turn it into the value that it outputs. This is a great technique to use when you need to turn dynamic values into hard-coded values in Excel.
| Tutorial Length (mm:ss): |
3:28 |
| Microsoft Office Program: |
Microsoft Office Excel |
