This Excel vba and macro tutorial shows you how to make your own Personal Macro Workbook. This will allow you to store often used macros in one place that is accessible from any workbook in Excel.
| Tutorial Length (mm:ss): |
3:35 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel vba create make personal macro workbook |
Assign a macro to a button, image, or shape in Excel; this allows you to make these items clickable so that a macro will run when they are clicked. You will also learn how to remove a macro from these items.
| Tutorial Length (mm:ss): |
3:38 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba assign image photo button shape |
Insert a macro into an Excel workbook, worksheet, or spreadsheet. This is the same as installing a macro into a workbook.
| Tutorial Length (mm:ss): |
4:50 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba insert install into workbook spreadsheet worksheet |
Remove or delete macros from Excel workbooks. This will show you how to remove one or all of the macros in a workbook.
| Tutorial Length (mm:ss): |
2:52 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba remove delete workbook |
This Excel vba and macro tutorial shows you how to change the name of a module. This will allow you to keep your macros better organized within the vba window.
| Tutorial Length (mm:ss): |
2:56 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba change name module |
This Excel macro and vba tutorial shows you how to rename a vba project.
| Tutorial Length (mm:ss): |
2:07 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba rename project vbaproject |
Learn how to password protect your vba projects and macros. This feature allows you to prevent a user from modifying, copying, or deleting any macros and vba code that you create. This is a great feature for adding security to your macros.
| Tutorial Length (mm:ss): |
3:31 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba project module password protect security |
This tutorial provides an introduction to creating, writing, and using macros and VBA in Excel. You will learn about the VBA window, where to install or create macros, how to write a macro, and how to save a workbook that contains a macro. The macro in this tutorial is a simple message box macro that will illustrate the basics of creating a macro in Excel.
| Tutorial Length (mm:ss): |
8:17 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba window make write create first easy introduction overview |
This tutorial will show you how to use VBA and macros in Excel in order to select an individual cell, multiple cells, ranges of cells, and multiple ranges of cells. This tutorial uses Range in VBA in order to select cells and ranges. This is one of the most important and most used concepts or features in VBA.
| Tutorial Length (mm:ss): |
6:34 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba select cells ranges multiple range |
This tutorial shows you how to use Range in VBA and macros in order to select single and multiple rows and columns within the spreadsheet. You will learn one of the most basic and most important features of VBA that will allow you to select cells in the spreadsheet.
| Tutorial Length (mm:ss): |
7:09 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba select rows columns cells range multiple contiguous separate |
This tutorial covers how to enter or input text, numbers, characters, or values into cells and ranges in Excel using VBA and macros. This is an important feature of VBA to learn in order to create more useful macros with varying types of output. This tutorial uses an invoice template as an example.
| Tutorial Length (mm:ss): |
7:50 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba input enter text numbers characters values cells range |
This tutorial shows you how to enter formulas and functions into Excel using VBA and macros. This tutorial includes entering formulas into cells and ranges of cells as well as an overview of absolute and relative cell references in VBA.
| Tutorial Length (mm:ss): |
8:27 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba input insert enter formulas functions cells range spreadsheet |
This tutorial covers the difference between the value and the formula property in vba and macros for Excel. There is an important distinction between the way these properties behave and it will save you a lot of time if you know these differences before coding problems arise.
| Tutorial Length (mm:ss): |
4:18 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba difference versus value formula property |
This tutorial shows you how to pull values from cells in Excel into a macro. This will allow you to use the value from a cell in a macro in many different ways and you will also learn how to output the value back into the spreadsheet.
| Tutorial Length (mm:ss): |
5:54 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba pull get read value cell spreadsheet |
This Excel tutorial shows you how to pull formulas and functions from cells into a macro. This will allow you to use this formula within the macro and even place it back in the spreadsheet. This tutorial uses the formula property of VBA.
| Tutorial Length (mm:ss): |
4:48 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba read pull formula function cells |
Assign the contents of cells in Excel to a variable in a macro. This will allow you to easily use cell values throughout a macro since you will only have to reference the variable to which these values are assigned. This tutorial covers one of the better methods of pulling cell values or contents into a macro.
| Tutorial Length (mm:ss): |
5:03 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba assign values cell contents variable |
This tutorial shows you how to remove, delete, and clear contents, values, formulas, functions, etc. from cells in Excel using a macro. This method will not clear any formatting that is in the spreadsheet; that is covered in another tutorial.
| Tutorial Length (mm:ss): |
2:57 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba clear delete remove cell contents values formulas |
This tutorial shows you how to clear all of the formatting from a cell or range of cells in Excel using a macro. This method will not remove or delete any of the contents of a cell.
| Tutorial Length (mm:ss): |
2:42 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba clear delete remove formatting formats |
This tutorial shows you how to automatically run a Macro or VBA code immediately after an Excel workbook has been opened. This feature allows your macro code to run before anything else happens within the Excel workbook. However, if a user has security settings that disable macros by default, your macro code may not always run. This feature will allow you to do things such as automatically upda...
| Tutorial Length (mm:ss): |
4:57 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training auto run macro when open workbook excel automatic vba macro |
This tutorial shows you how to automatically run a Macro or VBA code before an Excel workbook or spreadsheet is closed. Specifically, you will learn how to run a Macro after a user tries to close a workbook or Excel file but before the file is actually closed. This allows you to automatically perform tasks within the workbook, using VBA, which the user might otherwise forget to do, such as prote...
| Tutorial Length (mm:ss): |
4:41 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training run macro before close workbook excel vba code macro spreadsheet |
This tutorial shows you how to automatically run a Macro or VBA code before a spreadsheet or workbook is printed from Excel. Specifically, you will learn how to run a Macro after a user hits the print button or keyboard shortcut but before the spreadsheet is actually printed. This allows you to do things such as run code to automatically format a worksheet for printing, or prevent charts and pic...
| Tutorial Length (mm:ss): |
5:00 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training run macro before print excel vba code macro |
This tutorial shows you how to automatically run a Macro or VBA code each time a user enters or edits data within a worksheet in Excel. Specifically, you will learn how to have a macro automatically run after a user has entered data into a cell in Excel but not after each character or letter is typed into the cell. The macro will only automatically run after the user has entered data into a cell...
| Tutorial Length (mm:ss): |
6:28 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training auto run macro when enter data worksheet excel automatic vba macro |
This tutorial shows you how to automatically run a Macro or VBA code each time a cell is selected or made active within an Excel spreadsheet. Specifically, you will learn how to run a Macro after a user selects or moves to a cell within a worksheet in Excel. This allows you to automatically perform tasks within the workbook, using VBA, such as validating data that is being entered into a cell, e...
| Tutorial Length (mm:ss): |
5:44 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training run macro when cell selected spreadsheet excel vba automatic macro |
This tutorial shows you how to automatically run a Macro or VBA code after a user double-clicks a cell within a worksheet in Excel. The macro will automatically run immediately after a double-click of the mouse and before the user is able to edit or change the contents of a cell. However, this does not prevent a user from editing cell contents using other methods. This feature allows you to set...
| Tutorial Length (mm:ss): |
6:00 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training auto run macro on double click mouse excel automatically vba code macro |
This tutorial shows you how to automatically run a Macro or VBA code after a user right-clicks within a worksheet in Excel. The macro will automatically run immediately after a right-click of the mouse and before the normal right-click functions occur.
| Tutorial Length (mm:ss): |
6:00 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training auto run macro on right click mouse excel automatically vba code macro |
This tutorial shows you how to automatically run a Macro or VBA code each time a worksheet is added to an Excel workbook. Specifically, you will learn how to have a Macro automatically run after a user adds a worksheet in Excel but before the user has done anything within the worksheet. This allows you to do things such as automatically pre-format a spreadsheet immediately after it has been adde...
| Tutorial Length (mm:ss): |
3:45 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training auto run macro when add worksheet excel workbook automatic vba macro |
This tutorial shows you how to automatically run a Macro or VBA code when a worksheet in Excel is activated. Activating a worksheet in Excel is the same thing as navigating to a worksheet or clicking on its tab when on another worksheet. This allows you to automatically perform any desired task each time a specific worksheet or any worksheet in Excel is activated.
| Tutorial Length (mm:ss): |
5:11 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training auto run macro when worksheet activate go to excel automatic vba macro |
This tutorial shows you how to automatically run a Macro or VBA code when a worksheet in Excel is deactivated. Deactivating a worksheet in Excel is the same thing as navigating away from a worksheet. This allows you to automatically perform any desired task each time a specific worksheet or any worksheet in Excel is deactivated or made inactive.
| Tutorial Length (mm:ss): |
4:52 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training auto run macro when worksheet deactivated excel inactive automatic vba macro |
This tutorial shows you how to automatically run a Macro or VBA code when a workbook in Excel is activated. Activating a workbook in Excel means to navigate to the workbook. This occurs when a user switches between currently open workbooks within Excel. Automatically running a macro when a user activates a workbook in Excel allows you to perform many tasks such as updating information in the wo...
| Tutorial Length (mm:ss): |
4:03 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training auto run macro when workbook activated excel go to automatic vba macro |
This Excel VBA macro tutorial shows you how to move between worksheets in a workbook using a macro. This is the same thing as activating a worksheet in Excel or just clicking the desired worksheet tab by hand, except that it is being done with a macro.
| Tutorial Length (mm:ss): |
8:09 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic select activate open worksheet tabs sheets |
This Excel VBA and macro tutorial shows you how to add and name a worksheet, chart sheet, and any other type of sheet into an Excel workbook with a macro. This allows you to very quickly add new tabs to the current workbook. Also, this tutorial shows you how to use VBA to rename a tab after it has been added to the workbook.
| Tutorial Length (mm:ss): |
10:25 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic create add worksheet chart sheet tabs name rename |
This Excel VBA macro tutorial shows you how to rename a worksheet or tab in Excel using a macro. This allows you to very quickly change the name of any worksheet tabs within a workbook. Also, you will learn how to change the name of the current active worksheet in Excel.
| Tutorial Length (mm:ss): |
6:04 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic rename name worksheet tabs sheet |
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 |
| |
|
| Keywords: |
training excel macro vba visual basic add create multiple worksheet sheet tabs workbook |
This Excel VBA macro tutorial shows you how to remove or delete a worksheet from an Excel workbook. You will also learn how to prevent the confirmation prompt from popping up when you try to delete a sheet from a workbook. Preventing this confirmation prompt or alert from displaying will allow you to create a faster running and more automated macro.
| Tutorial Length (mm:ss): |
8:26 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic delete remove worksheet tabs sheet confirmation prompt alert |
This Excel VBA macro tutorial shows you how to copy worksheets within a workbook using VBA. This will allow you to make an exact duplicate of a worksheet and put that duplicate anywhere in the workbook.
| Tutorial Length (mm:ss): |
6:21 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic copy paste worksheet workbook duplicate |
This Excel VBA macro tutorial shows you how to move worksheets or tabs within a workbook using a macro. This allows you to reorder an Excel workbook very quickly and efficiently.
| Tutorial Length (mm:ss): |
4:52 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic change worksheet order move tabs |
This Excel VBA macro tutorial shows you how to hide and unhide worksheets in a workbook using VBA. This will allow you to prevent a user from seeing a worksheet while keeping the worksheet within the workbook. This is a great method to use to hide source data that you don’t want edited.
| Tutorial Length (mm:ss): |
4:41 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic hide unhide worksheet secure private |
This Excel VBA macro tutorial shows you how to securely and permanently hide a worksheet in Excel so that a user cannot unhide the worksheet. Using this method, one can only unhide the worksheet with a macro. This will eliminate the major security flaw that a basic worksheet hide causes, which is that any user could still unhide the worksheet by hand.
| Tutorial Length (mm:ss): |
4:43 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic permanently hide unhide worksheet tab secure prevent |
This tutorial will show you how to use VBA and macros in Excel in order to select an individual cell, multiple cells, ranges of cells, and multiple ranges of cells. This tutorial uses Range in VBA in order to select cells and ranges. This is one of the most important and most used concepts or features in VBA.
| Tutorial Length (mm:ss): |
6:34 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba select cells ranges multiple range |
This tutorial shows you how to use Range in VBA and macros in order to select single and multiple rows and columns within the spreadsheet. You will learn one of the most basic and most important features of VBA that will allow you to select cells in the spreadsheet.
| Tutorial Length (mm:ss): |
7:09 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba select rows columns cells range multiple contiguous separate |
This Excel VBA Macro tutorial shows you how to select all cells in a worksheet using VBA. This method will allow you to very quickly reference, use, and select all cells within any worksheet in an Excel workbook. This is a simple but important feature to learn for using VBA in Excel.
| Tutorial Length (mm:ss): |
2:56 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training select all cells excel worksheet vba visual basic applications |
This tutorial shows you how to pull values from cells in Excel into a macro. This will allow you to use the value from a cell in a macro in many different ways and you will also learn how to output the value back into the spreadsheet.
| Tutorial Length (mm:ss): |
5:54 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba pull get read value cell spreadsheet |
This Excel tutorial shows you how to pull formulas and functions from cells into a macro. This will allow you to use this formula within the macro and even place it back in the spreadsheet. This tutorial uses the formula property of VBA.
| Tutorial Length (mm:ss): |
4:48 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba read pull formula function cells |
This tutorial covers how to enter or input text, numbers, characters, or values into cells and ranges in Excel using VBA and macros. This is an important feature of VBA to learn in order to create more useful macros with varying types of output. This tutorial uses an invoice template as an example.
| Tutorial Length (mm:ss): |
7:50 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba input enter text numbers characters values cells range |
This tutorial shows you how to enter formulas and functions into Excel using VBA and macros. This tutorial includes entering formulas into cells and ranges of cells as well as an overview of absolute and relative cell references in VBA.
| Tutorial Length (mm:ss): |
8:27 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba input insert enter formulas functions cells range spreadsheet |
Assign the contents of cells in Excel to a variable in a macro. This will allow you to easily use cell values throughout a macro since you will only have to reference the variable to which these values are assigned. This tutorial covers one of the better methods of pulling cell values or contents into a macro.
| Tutorial Length (mm:ss): |
5:03 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba assign values cell contents variable |
This VBA and Macro tutorial for Excel shows you how to use Named Ranges within VBA. This means that you can reference any named range from within a workbook using VBA. This easier than hard coding cell references and will save you time when writing code.
| Tutorial Length (mm:ss): |
3:59 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training named range reference use excel macro vba select range cells name cell |
This Excel Macro VBA tutorial shows you how to reference inactive worksheets and tabs using VBA. This method allows you to not have to activate or select each worksheet before you perform operations within that worksheet. This will allow you to create much faster running macros that require less code. In this example, you will learn how to input values into cells on inactive worksheets in Excel...
| Tutorial Length (mm:ss): |
5:40 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training inactive worksheet cells reference range excel macro vba input insert values edit cells |
This Excel VBA macro tutorial shows you how to add formatting to cells in a worksheet in Excel, specifically, you’ll learn how to add bold, italics, single underline, double underline, accounting underline, and strikethrough to the contents of cells.
| Tutorial Length (mm:ss): |
12:29 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic format formatting bold italic underline single double accounting strikethrough line through cell |
This Excel VBA macro tutorial shows you how to add subscript and superscript formatting to cell contents using VBA. As well, this tutorial also covers how to remove subscript and superscript formatting with a macro in Excel.
| Tutorial Length (mm:ss): |
5:03 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic format formatting subscript superscript script text |
This Excel VBA macro tutorial shows you how to merge and unmerge cells within the worksheet. This is a great feature to use when you don’t want to resize columns to fit a lot of text and when you need to apply a header across multiple columns. This tutorial will also show you how to center text within merged cells using VBA.
| Tutorial Length (mm:ss): |
6:10 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic format formatting combine merge unmerge cells worksheet title header center text |
This Excel VBA macro tutorial shows you how to copy formatting from one cell and apply it to other cells within the worksheet using VBA. This will allow you to very quickly and efficiently format an entire document using very few lines of code within the macro.
| Tutorial Length (mm:ss): |
6:15 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic format formatting copy paste formats painter pastespecial special |
This Excel VBA macro tutorial shows you how to wrap text using VBA. This will allow you to ensure that all of a cell’s contents fit within the cell. This is a useful method because it will not change any of the formatting for the cell’s contents. Instead, using wrap text will simply resize the cell in order to fit everything within the cell.
| Tutorial Length (mm:ss): |
2:45 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic format formatting wrap text remove add cell contents |
This Excel VBA macro tutorial shows you how to shrink cell contents using VBA so that everything will fit within one cell in the worksheet. This method will allow you to ensure cell contents do not spill over into other columns while at the same time retaining all of the original formatting for the cell’s contents.
| Tutorial Length (mm:ss): |
3:35 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic format formatting shrink text cell contents fit |
This Excel VBA macro tutorial shows you how to change the orientation of a cell using VBA. The orientation of a cell’s contents is the same as its degree or angle within the spreadsheet. This method will allow you to tilt cell contents up or down plus or minus 90 degrees.
| Tutorial Length (mm:ss): |
6:09 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic format formatting orientation angle degree cell contents text |
This Excel VBA macro tutorial shows you how to automatically resize columns and rows to fit all of the data contained within the columns and rows using VBA in Excel. This feature will allow you to prevent data from overlapping and extending beyond the limits of a cell.
| Tutorial Length (mm:ss): |
4:41 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic format formatting auto automatically resize column columns row rows fit autofit |
This IF statement tutorial for VBA and macros shows you how to make a basic IF THEN statement in VBA. This tutorial covers every step of creating an IF statement in VBA. The type of IF statement covered here is called a Block IF statement. This type of IF statement allows users to put as much code as they want or need within an IF statement. Also, this tutorial covers the comparison operators ...
| Tutorial Length (mm:ss): |
11:27 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training if then statement vba block macro excel comparison condition create true false overview operator tip 6 |
This IF statement tutorial for VBA and macros shows you how to make and use an IF THEN ELSE statement in VBA. This will allow you to create an IF statement that will do something if a condition evaluates to true and do something else if the condition evaluates to false. This is one of the building blocks for IF statements in VBA and macros.
| Tutorial Length (mm:ss): |
10:15 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training if then statement else vba macro excel condition create true false visual basic applications |
This IF statement tutorial for VBA and macros shows you how to create an IF THEN ELSEIF statement in VBA. This will allow you to create an IF statement that will be able to check for multiple conditions and then run different code based on whichever condition evaluates to true. This is similar to, but not completely the same as, putting multiple contiguous IF statements within your macro code. ...
| Tutorial Length (mm:ss): |
16:03 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training elseif else if then statement vba macro excel condition create true false visual basic applications |
This IF statement tutorial for VBA and macros shows you how to create an IF THEN ELSEIF ELSE statement in VBA. This is the most complex and also complete version of an IF statement in VBA. This type of IF statement will allow you to check multiple different conditions with IF and ELSEIF and also to run code if all of the conditions within the IF statement evaluate to false. This tutorial shows ...
| Tutorial Length (mm:ss): |
10:30 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training elseif else if then else statement vba macro excel condition visual basic applications |
This IF statement tutorial for VBA and macros provides an overview of the syntax for IF statements in VBA. This tutorial covers basic block IF statements as well as IF statements with Else and ElseIf. This tutorial covers only the syntax for an IF statement in VBA.
| Tutorial Length (mm:ss): |
5:22 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training if then statement else elseif vba macro excel overview syntax quick condition visual basic applications |
This tutorial shows you how to use the IIF or Immediate IF function in VBA and macros. This is a VBA function that behaves like an IF statement. The benefit of using this function is that it is easy and quick to implement and it will make some decision processes easier to create. However, there are some things to watch out for when using this function, and all of that is also covered in this tu...
| Tutorial Length (mm:ss): |
12:12 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training IIF function vba excel immediate macro if then one line single function logic formula visual basic |
This IF statement tutorial for VBA and macros shows you how to create a one line IF statement in VBA. This allows you to streamline your code by allowing you to make small and useful IF statements, where needed, without having to disrupt code structure with a multi-line or block IF statement. This method will allow you to create a basic IF statement as well as an IF THEN ELSE statement on one li...
| Tutorial Length (mm:ss): |
8:04 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training one single line if then statement one vba else macro excel condition create true false visual basic |
This IF statement tutorial for VBA and macros shows you how to nest multiple IF statements within each other. There are many simple and complex examples of nesting IF statements in this tutorial. This includes nesting small block IF statements to nesting IF ELSEIF and IF ELSEIF ELSE statements in VBA. This tutorial covers everything you need to know about nesting IF statements in VBA and macros...
| Tutorial Length (mm:ss): |
10:52 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training nested if statement multiple nest vba excel inside macro visual basic logic code condition |
This IF statement tutorial for VBA and macros will show you how to test for multiple conditions at once within an IF statement in VBA using AND. This method will allow you to prevent an IF statement from running unless multiple conditions evaluate to true. Using AND is a great way to improve the usability and power or logic of your IF statements in VBA.
| Tutorial Length (mm:ss): |
7:48 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training AND if then statement else vba macro excel condition create AND |
This IF statement tutorial for VBA and macros shows you how to use OR in order to test for multiple conditions at once within an IF statement in VBA. This method allows you to put many conditional tests in the condition for an IF statement. Using OR, you will be able to create more powerful and useful IF statements. This is a great VBA feature to learn in order to improve your code.
| Tutorial Length (mm:ss): |
7:43 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training OR if then statement else vba macro excel or multiple condition basic applications condition |
This IF statement tutorial for VBA and macros shows you how to use AND with OR within the conditional test in an IF statement in order to test for multiple conditions at once. Basically, this will allow you to test multiple values at once in order to determine if an IF statement should be run. This tutorial will show you how to add more logic to your logical statements and code in VBA.
| Tutorial Length (mm:ss): |
6:56 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training AND OR if then statement vba macro excel logic multiple conditions and or |
This VBA and macro IF statement tutorial shows you how to use complex conditions within IF statements in VBA. You will learn how to use functions, AND, OR, and values from cells within the conditional test of an IF statement. This tutorial shows you the diversity of values that you can test for using an IF statement and will help you to add better logic to your VBA code.
| Tutorial Length (mm:ss): |
9:00 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training condition complex if then statement function vba macro excel condition visual basic applications examples |
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 ...
| Tutorial Length (mm:ss): |
8:51 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba while wend loop loops statement |
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...
| Tutorial Length (mm:ss): |
10:00 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba do while loop loops statement |
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 |
| |
|
| Keywords: |
training excel macro vba do until loop loops statement |
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 |
| |
|
| Keywords: |
training excel macro vba do while until loop versus compare compared |
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 |
| |
|
| Keywords: |
training excel macro vba exit stop cancel terminate do while until loop loops statement |
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 |
| |
|
| Keywords: |
training excel macro vba visual basic array arrays overview introduction |
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 |
| |
|
| Keywords: |
training excel macro vba visual basic static basic array variable declare create access use insert |
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 compr...
| Tutorial Length (mm:ss): |
19:36 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic array arrays dynamic declare create insert redim preserve elements values input output |
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 |
| |
|
| Keywords: |
training excel macro vba visual basic static basic array variable loop through retrieve pull values elements |
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...
| Tutorial Length (mm:ss): |
8:52 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic loop through dynamic array elements retrieve output view upper lower bound |
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 |
| |
|
| Keywords: |
training excel macro vba visual dynamic array increase decrease size upper lower bound index number store elements |
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 cove...
| Tutorial Length (mm:ss): |
5:45 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic dynamic array variable insert add elements values size increase |
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 |
| |
|
| Keywords: |
training excel macro vba visual dynamic array add elements items values loop for next quickly |
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 |
| |
|
| Keywords: |
training excel macro vba visual basic array arrays store values insert |
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 |
| |
|
| Keywords: |
training excel macro vba visual basic array output retrieve values elements data from |
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 |
| |
|
| Keywords: |
training excel macro vba visual basic static array variable clear remove erase delete values items elements |
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 de...
| Tutorial Length (mm:ss): |
5:35 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic dynamic array clear erase delete values elements items |
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 |
| |
|
| Keywords: |
training excel macro vba visual basic isarray variable array check determine static dynamic |
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 |
| |
|
| Keywords: |
training excel macro vba visual basic array static dynamic first index number lower bound option base set |
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 ele...
| Tutorial Length (mm:ss): |
9:11 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training excel macro vba visual basic retrieve find number elements items index array variable |
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 |
| |
|
| Keywords: |
training excel macro vba visual basic determine first last upper lower bound index number array |
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 |
| |
|
| Keywords: |
training excel macro vba visual basic array convert string words split keywords |
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 |
| |
|
| Keywords: |
training excel macro vba visual basic array string convert words join keywords |
This tutorial shows you how to combine multiple separate pieces of text, strings, or information within VBA and macros using concatenation. This will allow you to put separate pieces of information into one variable or one string and this method is also the basis for many calculations within VBA and macros. This is a thorough concatenation tutorial that includes multiple examples which show you ...
| Tutorial Length (mm:ss): |
8:18 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training concatenate combine text strings variables vba macros string functions concatenation |
This tutorial shows you how to extract characters from the left of a string or text using VBA and macros. This is a text extraction and manipulation feature within VBA and it allows you to quickly and easily take apart a string. This tutorial covers examples that show you exactly how to extract text from the left of a string and how this feature can be used in more complicated applications.
| Tutorial Length (mm:ss): |
6:40 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training extract characters left string vba macros excel access string functions |
This tutorial shows you how to calculate the length of a string within VBA and macros. The feature illustrated in this tutorial is covered with many examples and a thorough explanation of how to use it. This feature is one of the basic building blocks for more complex text manipulation and extraction applications within VBA and macros.
| Tutorial Length (mm:ss): |
6:14 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training calculate string length vba macros excel access text word string functions |
This tutorial shows you how to reverse a string in VBA and macros. This feature will allow you to quickly and easily completely reverse the characters in a string. You can make text read backwards or forwards using this method. This will save you a lot of time when you need to format any amount of text in reverse or backwards.
| Tutorial Length (mm:ss): |
4:58 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training reverse string vba macros backwards text excel access string |
This tutorial shows you how to change text to upper case text using VBA and macros. This is especially helpful if you need to quickly format a large amount of text in upper case letters and also when you need to compare text strings and you don’t want any potential difference in text case to affect this comparison.
| Tutorial Length (mm:ss): |
5:10 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training text upper case macro vba uppercase excel access change string function |
This tutorial shows you how to change text to lower case text using VBA and macros. This is especially helpful if you need to quickly format a large amount of text in lower case letters and also when you need to compare text strings and you don’t want any potential difference in text case to affect this comparison.
| Tutorial Length (mm:ss): |
5:07 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training text lower case macro vba lowercase excel access change string function |
This tutorial shows you how to quickly repeat a single character within VBA and macros. This feature allows you to very quickly create a string of a desired length without much programming code and can therefore save you a lot of time within VBA.
| Tutorial Length (mm:ss): |
3:33 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training repeat single character text vba macros excel access text string |
This tutorial shows you how to remove any extra or blank spaces from the left and right of a text string within VBA and macros. This feature allows you to quickly clean or scrub data to ensure that there are no extra spaces to the left or right of it that might cause problems later within the code or application. This is a great feature to use when you have code that collects or uses text or str...
| Tutorial Length (mm:ss): |
7:00 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training remove blank spaces string vba macros excel access left right text function empty |
This tutorial shows you how to remove any extra or blank spaces from the left of a text string within VBA and macros. This feature allows you to quickly clean or scrub data to ensure that there are no extra spaces to the left of it that might cause problems later within the code or application. This is a great feature to use when you have code that collects or uses text or strings that come from...
| Tutorial Length (mm:ss): |
5:56 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training remove blank spaces left string vba macros excel access text function empty |
This tutorial shows you how to remove any extra or blank spaces from the right of a text string within VBA and macros. This feature allows you to quickly clean or scrub data to ensure that there are no extra spaces to the right of it that might cause problems later within the code or application. This is a great feature to use when you have code that collects or uses text or strings that come fr...
| Tutorial Length (mm:ss): |
7:02 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training remove blank spaces right string vba macros excel access text function empty |
This Excel UserForm tutorial shows you how to run or open a UserForm by clicking a button within a worksheet in Excel. This allows you to have quick and easy access to any UserForm that you create and is the way that most people access their UserForms. Specifically, you will learn what VBA code you need to write to open or run the UserForm; how to insert a button into a worksheet in Excel; and h...
| Tutorial Length (mm:ss): |
4:34 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training run open userform button excel worksheet load activate access view |
This Excel VBA UserForm tutorial shows you how to close a UserForm using a button within the form. In this tutorial, you will learn how to add a button to the form, rename the button, and make it so that clicking that button will close the UserForm. You will also learn the default method for closing a form.
| Tutorial Length (mm:ss): |
4:40 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training close userform exit button excel unload cancel |
This Excel UserForm tutorial shows you how to get values from a UserForm. You will learn how to get the values that a user inputs into the controls within a form and then how to do whatever you need with those values. This includes getting the input from a Textbox, ComboBox, ListBox, CheckBox, OptionButton (Radio Button), and ToggleButton. Every step of this process is covered in this tutorial,...
| Tutorial Length (mm:ss): |
8:10 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training retrieve input values controls userform excel vba user form textbox combobox listbox text data use |
This Excel UserForm tutorial shows you how to reset or clear the values for UserForm controls. You will learn how to reset all controls back to the default values as well as how to simply clear all input from the controls within the form. This means that you will be able to remove all text from a TextBox, selections from a ComboBox or ListBox, clear any CheckBoxes or OptionButtons, as well as re...
| Tutorial Length (mm:ss): |
11:05 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training clear reset values controls userform excel delete remove textbox combobox listbox checkbox optionbutton togglebutton |
This Excel UserForm tutorial shows you how to change the title of the UserForm. The title is the text that appears in the bar at the top of the form. By default, the text reads something like UserForm1, and this does not look very professional. In addition to changing the title of the UserForm, you will learn how to change the name of the form.
| Tutorial Length (mm:ss): |
4:14 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training title text userform user form excel caption name |
This Excel UserForm tutorial shows you how to change the text or label of a button in an Excel UserForm. You will learn how to add a command button to a UserForm; how to change the text displayed on the button; and, how to change the name of the button. This tutorial covers all of the basics related to command buttons in Excel UserForms.
| Tutorial Length (mm:ss): |
3:37 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training command button text label caption userform user form excel |
This Excel UserForm tutorial shows you how to view the toolbox that allows you to add elements to a UserForm. This toolbox is normally visible in the VBA Editor window; however, it is very easy to accidentally close, and, when closed, you aren’t going to be able to add design elements to your form. This tutorial shows you the steps required to get the toolbox window back within the VBA editor wi...
| Tutorial Length (mm:ss): |
1:50 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training toolbox userform excel show insert elements button item window box user form view |
This Excel UserForm tutorial shows you how to add a text label to a UserForm in Excel. A label is just text that you can put into a UserForm in order to tell a user what to input and where to input it. Labels are essentially all of the text that you see within a UserForm. This tutorial shows you how to add labels and change the display text of labels in a UserForm.
| Tutorial Length (mm:ss): |
4:34 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training text label userform excel user form text |
This Excel VBA tutorial shows you how to add a ComboBox (Drop Down List or Menu) to a UserForm (User Form) in Excel. You will learn how to create the drop down list, how to edit the drop down list, and how to add, edit, and remove items from the drop down list. There are five different examples of how to add data to the ComboBox and thorough explanations with each example. Some examples show yo...
| Tutorial Length (mm:ss): |
17:20 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training combobox dropdown menu list userform vba excel user form combo box drop down fill populate create drop down menu list |
This Excel UserForm tutorial shows you how to add a tip to the UserForm that will appear when you hover over a control, such as a TextBox, CommandButton, etc. This feature allows you to save space on the UserForm by putting any helpful or auxiliary text or tips into a box that only appears when you hover over a specified UserForm control.
| Tutorial Length (mm:ss): |
4:00 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training tip text hover userform control excel user form tips text help |
This Excel UserForm tutorial shows you how to remove the extra spaces from the left of a TextBox. By default, UserForm TextBox’s contain an extra space or margin to the left of any text that is input into it. This can be very annoying and does not look professional. Note, removing this extra space is sometimes referred to as ‘left justifying’ the text within a TextBox.
| Tutorial Length (mm:ss): |
2:41 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training left justify spaces textbox userform excel remove extra space text box user form |
This Excel UserForm tutorial shows you how to limit the number of characters that a user can enter into a TextBox control within a UserForm. This is a form of data validation and allows you to prevent incorrect values from being input into the form. Note, this tutorial does not show you how to prevent certain text or numbers from being entered into a TextBox; users will still be able to enter an...
| Tutorial Length (mm:ss): |
3:21 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training limit max characters length textbox userform excel text box user form maximum |
This Excel VBA UserForm tutorial shows you how to add data from an Excel UserForm onto the next blank row or line in a worksheet. This allows you to use Excel as a sort of database for information. This tutorial covers how to setup the UserForm, how to add VBA code to the UserForm, and what VBA code to use to ensure that data from the form will always be input into the next blank row within the ...
| Tutorial Length (mm:ss): |
13:15 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training userform user form excel new blank row line add entry input data database worksheet |
This Excel VBA UserForm tutorial shows you how to separate VBA code from the UserForm. It is a best practice to separate all of the functional VBA code from the VBA code that is required directly by the form. Doing this, you will have more structured code that is easier to follow and easier to maintain. This tutorial covers all of the steps that you need to follow in order to take existing code...
| Tutorial Length (mm:ss): |
10:21 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training separate vba userform code excel module break split vbe best practices name |
This Excel UserForm tutorial shows you how to prevent a user from typing incorrect or wrong values into a ComboBox in a UserForm. This will allow you to prevent a user from being able to enter a value into a ComboBox that is not actually listed within it. This method is a very easy way to implement data validation and allows you to validate data without any VBA code on the backend.
| Tutorial Length (mm:ss): |
4:11 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training combobox userform prevent values entered excel validate data validation insert stop |
This Excel VBA UserForm tutorial shows you how to automatically close a UserForm after an action has occurred within the form. This action can be anything from the user submitting data through the form to the user saving data from the form and so on. Basically, you will learn how to programmatically close the UserForm at any time during the execution of code within the form. This will allow you...
| Tutorial Length (mm:ss): |
5:00 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training close userform automatically after exit excel after action unload cancel |
This Excel UserForm tutorial shows you how to set an image as the background for a UserForm. You will learn how to insert the image and how to change the position and resizing attributes of the image within the form. Also, this tutorial explains all of the steps that you need to go through in order to make a professional looking custom background image for your form. Doing this, you will be abl...
| Tutorial Length (mm:ss): |
5:41 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training picture image userform background excel user form photo gradient professional picture photo |
This Excel UserForm tutorial shows you how to change the color of everything within a UserForm. You will learn how to change the color of a TextBox, ComboBox, ListBox, the entire UserForm, and anything else that you can put into a UserForm. Adding color to your UserForms is a great way to make them stand out or blend in with your worksheet and this tutorial explains everything that you need to k...
| Tutorial Length (mm:ss): |
5:24 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training color background userform controls excel button input text box list change |
