The Split function splits a string based on the occurrence of a specific character (called a delimiter) and returns the results in an array. In this lesson, we split a cell's value by the presence of slashes and paste the results in...

The For loop is a fundamental building block of programming. It allows us to iterate, or to repeat a certain block of instructions a given number of times. In this lesson, we explore the syntax for For loops and implement a few...

Multiple pieces of conditional logic can be chained together with the If, ElseIf and Else keywords. In this lesson, we write a procedure that takes 3 possible paths of execution.
r/>
This clip is from the chapter "Conditionals"...

Master Solving word problems with changing angles

In this section of the course, we take a deep dive into the Range, the most popular object in the Excel Object Model. We begin with the Select method, which highlights the range's boundaries on the spreadsheet.
r/>
This clip is...

In this lesson, we use the Workbooks. method to close every open workbook in Excel. We also configure the procedure to disable alerts temporarily to avoid halting execution.
r/>
This clip is from the chapter "Object Deep Dive"...

In this lesson, we'll explore some tips for writing cleaner and more elegant VBA code.
r/>
This clip is from the chapter "Variables and Data Types" of the series "Excel VBA Programming–The Complete Guide".In this section, we...

In this lesson, we'll explore the benefits of comments to the developer and practice writing them in the context of a procedure.
r/>
This clip is from the chapter "The Visual Basic Editor" of the series "Excel VBA...

A procedure is a grouped set of instructions / code that accomplishes some kind of goal. We'll also talk about some of the common syntactical errors made when writing out procedures. In this lesson, we'll dive into the syntax to...

The Format menu in the Visual Basic Editor offers options for aligning, grouping, and resizing one or more form controls. In this lesson, we apply these techniques to the controls in our employees UserForm.
r/>
This clip is...

The Label form control adds a static piece of text to a UserForm. The Textbook form controls is an input box for the user to enter text. In this lesson, we add these two form controls to our UserForm.
r/>
This clip is from the...

The UserForm is a custom form that can be configured with labels, textboxes, buttons and more. In this lesson, we create our first UserForm and begin our discussion of popular naming conventions in the VBA community.
r/>
This...

The Worksheet_Change event shoots off when the user edits or deletes a value from a Range in the worksheet. In this lesson, we use it to create a basic pounds-to-kilograms converter that takes a numeric value from column A, applies a...

Deleting rows from a spreadsheet can be a risky operation --- if moving downwards in direction, there's a risk that some rows will NOT be deleted. In this lesson, we explore iteration in reverse (from a larger number to a smaller one)...

The With - End With construct is a shorthand syntax that allows for multiple properties to be overwritten on an object. In this lesson, we practice modifying the Name, Size, Bold and Italic properties on the Font object.
r/>
...

A Boolean is a special data type whose value can only be True or False. In this lesson, we explore the concept of truthiness and falsiness with the help of common mathematical operations and string comparisons.
r/>
This clip is...

In certain cases, VBA allows us to traverse the Excel object model in reverse --- from the bottom up. One such example is the Range.Worksheet property, which returns a Worksheet object that encloses a Range. In this lesson, we practice...

Excel offers several paste options in its user interface -- pasting just the value, just the formats, and more. In this lesson, we walk through how to emulate this feature in VBA with the help of predefined enumerations.
r/>
...

Copy and paste --- is there a more common task in Excel? In this lesson, we use the Range.Copy and Range.Cut methods to copy, cut, and paste text across a spreadsheet.
r/>
This clip is from the chapter "Range Actions" of the...

In this quick lesson, we dive into 3 total methods on a Range object:

• ClearContents, which removes the value from a R
ange.
• ClearFormats, which removes the formatting of a cell (font, border, backgr
ound, etc)
•...

In this lesson, we practice selecting single-cell Range objects with the Cells property before applying the Resize property to expand the selection to multi-cell Ranges.
r/>
This clip is from the chapter "Range References" of...

In this lesson, we write values to the four corners of the spreadsheet using the Range.End property and discuss the predefined constants (enumerations) passed in as arguments.
r/>
This clip is from the chapter "Range...

In this lesson, we explore this with the context of Worksheet objects inside the Worksheets collection.
r/>
This clip is from the chapter "The Fundamentals of the Excel Object Model" of the series "Excel VBA Programming–The...

The F8 key allows us to step through the lines of a procedure step by step. In this lesson, we see how this functionality grants tremendous power when debugging a complex piece of code.
r/>
This clip is from the chapter...