In this lesson, we explore the Rows and Columns properties, which are available on both the top-level Application object and a specific Range. The two can be used to target complete rows or columns, within the spreadsheet or within a...

In this lesson, we invoke the Workbook.Active method to simulate a user click on a workbook and make it the ActiveWorkbook. We also review the ActiveSheet property, which targets the currently highlighted worksheet.
r/>
This...

The Exit Sub keywords terminate a procedure prematurely, before it reaches its last line of code. It's an effective technique to combine with conditional logic --- proceed if all the pieces fall into place, exit otherwise. In this...

The CommandButton is a clickable button that trigger an event procedure. In this lesson, we add 3 buttons to our form -- Submit, Cancel and Hide.
r/>
This clip is from the chapter "User Forms" of the series "Excel VBA...

In the first of a 3-part series, we introduce the ListBox form control for displaying a list of predefined values for the user to choose from. We hardwire our list to show the names of all of the workbook's sheets.
r/>
This...

The On Error Go To keywords redirect the pathway of a procedure to a specially designated section. In this lesson, we set up an example and discuss why the Exit Sub keywords have to be used to avoid running into the code...

The VBA object includes many helper methods to assist the developer with common utility operations. In this lesson, we explore the LCase, UCase, Len, Trim, and InStr methods for working with strings.
r/>
This clip is from the...

The LBound and UBound methods return the smallest and greatest index positions of an array. In this lesson, we utilize these values to write a flexible, dynamic loop procedure.
r/>
This clip is from the chapter "Arrays" of the...

Arrays can easily be populated with values from the worksheet using a basic For loop. In this lesson, we perform a popular string cleaning operation --- trimming the leading and trailing whitespace of a string -- on a column of values...

The Range.ColumnWidth and Range.RowHeight properties can resize the row and height of one or more columns or rows. In this lesson, we play around with these features in the Immediate Window.
r/>
This clip is from the chapter...

The Workbook. method accepts a SaveChanges parameter; pass it a Boolean value of True to save the workbook before closing. In this lesson, we practice this concept by writing values to our red and blue workbooks.
r/>
This clip...

In this lesson, we offer a review of the Workbooks.Open method and introduce the Workbook.Path property. The former is used to open a single workbook while the latter is used to identify the direction that a workbook exists in. It's...

Learn more about calling procedure.<br/<br/>>

This clip is from the chapter "Procedures" of the series "Excel VBA Programming–The Complete Guide".We look into variable scopes in procedures.

The Checkbox is an ideal form control for simple Yes or No questions. In this lesson, we create a new UserForm that allows the user to choose to clear cells and / or save the workbook. We also dive a bit into modifying the aesthetics...

The ListBox offers a way for the user to select more than one option. In this lesson, we enable this setting and configure our code to delete all the worksheets that a user selects from the list.
r/>
This clip is from the...

The Range.RemoveDuplicates method removes the repeating occurrences of a value in a given range. In this lesson, we use it to clear a list of duplicate names and show how arrays can be fed as arguments to methods.
r/>
This clip...

The Worksheet.Move method moves a worksheet to a different position in the order of workbook sheets. In this lesson, we explore the signature of the method including its familiar Before and After parameters.
r/>
This clip is...

The Worksheets.Add method creates a new worksheet in the current Workbook. It accepts either one of two optional arguments, Before and After, that determine where the new worksheet will be placed.
r/>
This clip is from the...

In this lesson, we practice declaring a procedure with Boolean variables and discuss the contexts in which they can be used.
r/>
This clip is from the chapter "Variables and Data Types" of the series "Excel VBA...

In this lesson, we use the official Microsoft Developer Network documentation to look up the Worksheet object and the Protect method. We discuss the idea of method parameters, which are names we give to expected inputs. We also explore...

In this lesson, we wire up the final Command Button on our UserForm to capture the user's input and populate it on the spreadsheet.
r/>
This clip is from the chapter "User Forms" of the series "Excel VBA Programming–The...

In this lesson, we wire up a Command Button event procedure to delete the single worksheet the user has selected from the ListBox.
r/>
This clip is from the chapter "User Forms" of the series "Excel VBA Programming–The...

In this lesson, we create our first event procedure to react to the Change event on our Textbox. Upon any user edit, it outputs the current entry to the Immediate Window.
r/>
This clip is from the chapter "User Forms" of the...

In this lesson, we play around with the Object Browser and see how we can use it access online documentation on the MSDN as well.
r/>
This clip is from the chapter "Objects and Methods" of the series "Excel VBA...