The Worksheet.Copy method copies the contents of a worksheet to a new worksheet. When invoked with no arguments, it will create the copy in a brand new workbook. With either a Before or After argument, the copy will be placed in the...

In this lesson, we explore the Name property on both a Worksheet and Workbook object. The Name property is only readable on a Workbook but is readable and writeable on a Worksheet. The key takeaway is that object design differs; just...

The For Each construct iterates over every single object in a collection. In this lesson, we practice iterating over the Workbooks and Worksheets collections.
r/>
This clip is from the chapter "Iteration" of the series "Excel...

In this lesson, we wire up the UserForm to iterate over all of the workbook's worksheets and normalize the font name and size based upon the user's ComboBox selections.
r/>
This clip is from the chapter "User Forms" of the...

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 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...

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 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 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 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 video, the teacher demonstrates how to use the VBA editor tool to create and name worksheets, add them to a workbook, and rename them. The teacher also shows how to move and manipulate the data using code, rather than doing it...

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...

In this video I go over the different worksheets that I created to help you and your students. A teacher in the comments brought up a good question. It's not just immoral to use my worksheets without getting an annual license, it is...

In This Episode, Tyler Teaches Us About How to Create Answer Sheets for Every Student in Google Classroom

The new AONest Learning Management System by Anishnabeg Outreach provides users with the tools needed to develop essential life skills and to navigate mental health challenges that may make day-to-day life difficult. It also provides...

Meet the social media generation.

Here students are encourage to use their smartphones to communicate with the teachers and peers via social me
dia.
Allie Meyer is one of...