Breakpoints force a procedure to halt execution at one or more specified lines. In this lesson, we practice enabling and disabling breakpoints in our code.
r/>
This clip is from the chapter "Debugging" of the series "Excel VBA...

In this lesson, we continue our exploration of additional datetime functions on the VBA helper object including Year, Month, Day, Hour, Minute, and Second. We also dive into the Weekday, WeekdayName and MonthName functions to discover...

In this lesson, we dive deeper into the MsgBox method including its Buttons and Title parameter. We modify the aesthetics of the alert, including the clickable buttons and the information icon.
r/>
This clip is from the chapter...

In this video, you’ll learn how to sort your arrays. It doesn’t make much sense to have completed todos at the top of the list. What if we could keep the completed ones at the bottom and the incomplete ones up top?
r/>
This...

In this video, we'll cover what is JSON.
r/>
This clip is from the chapter "JavaScript JSON and AJAX" of the series "HTML CSS and JavaScript for Beginners - A Web Design Course".This section introduces JSON and AJAX. Learn...

In this video, Justin covers the concept of arrays in programming using Small Basic. He explains how arrays are used to store multiple items of information and demonstrates how to create and manipulate arrays to generate random names...

Divide decimals by whole numbers using a 10x10 array.

So far, we've used variables to hold a single value. Arrays allow you to reference multiple values in a list form using a single variable name.

Interpret products using arrays.

Functional Programming - Lambda Expressions and Streams: Functional Programming Questions and Answers
r/>
This clip is from the chapter "Functional Programming - Lambda Expressions and Streams" of the series "Java Interview...

Other Newer Features - ES2015+: Destructuring
<
br/>
This clip is from the chapter "Other Newer Features - ES2015+" of the series "Modern JavaScript from the Beginning".In this section, you will learn about the newer features of...

This video demonstrates how to use the for-in loop.
r/>
This clip is from the chapter "Objects and Arrays" of the series "TypeScript for Beginners".This section introduces you to objects and arrays and demonstrates how to use...

In this video, we'll cover JSON as data.
r/>
This clip is from the chapter "JavaScript JSON and AJAX" of the series "HTML CSS and JavaScript for Beginners - A Web Design Course".This section introduces JSON and AJAX. Learn...

In this video, we'll cover JavaScript string methods.
r/>
This clip is from the chapter "Learn JavaScript Section" of the series "HTML CSS and JavaScript for Beginners - A Web Design Course".Learn how to write JavaScript,...

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

In this video, you’re going to learn how to filter arrays. Imagine you want to filter all the todos down to just the todos that still need to be completed.
r/>
This clip is from the chapter "Arrays" of the series "The Modern...