Curated Video
Excel VBA Programming The Complete Guide - The Workbook.SaveAs and Workbook.Save Methods
In this lesson, we walk through the complete process of creating a new workbook, saving it, making changes, saving it again, and closing it. We introduce the SaveAs and Save methods on the Workbook object and explore their different use...
Curated Video
Excel VBA Programming The Complete Guide - Variable Scope
Variables have scope, which describes the boundary or context in which the variable can be used. In this lesson, we explore the 3 types of variable scope: • local / procedure / macro scope - variables declared in a procedure are limited...
Curated Video
Excel VBA Programming The Complete Guide - Unload and Hide a UserForm
There are two ways to "shut down" a UserForm: unloading, which clears all of its data and hiding, which hides it from the screen but preserves the user's inputs. In this lesson, we wire up our two Command Buttons to utilize these two...
Curated Video
Excel VBA Programming The Complete Guide - Select Case
Multiple If statements can quickly clutter up a procedure. The Select Case construct offers a convenient alternative. In this lesson, we'll explore the syntax for Select across a variety of examples. This clip is from the chapter...
Curated Video
Excel VBA Programming The Complete Guide - The Application.ScreenUpdating Property
The Application.ScreenUpdating property can be set to False to disable updates to the Excel interface. One way to optimize the speed of a macro is to turn the property off at the beginning of execution and reenable it at the end. In this...
Curated Video
Excel VBA Programming The Complete Guide - The NOT Operator
The NOT operator reverses a Boolean value. In this lesson, we use it to design our own implementation of Excel's bolding feature. This clip is from the chapter "Conditionals" of the series "Excel VBA Programming–The Complete Guide".In...
Curated Video
The Complete React Developer Course (with Hooks and Redux) - Array Data in Firebase: Part I
In this video you'll learn about arrays in Firebase. Firebase doesn't support arrays by default. We'll talk about why that is and what you can do to manage a list of expenses. This clip is from the chapter "Firebase 101" of the series...
Curated Video
The Modern JavaScript Bootcamp (2019) - Manipulating Arrays with Methods
In this video, you’re going to learn how to manipulate an existing array. This includes adding, removing, alerting, and replacing array items. This clip is from the chapter "Arrays" of the series "The Modern JavaScript Bootcamp...
Curated Video
Java Programming for Complete Beginners - Java 16 - Step 16 - Understanding Data Structures - Tree - Sorted Order
In this session, we will understand data structures - tree - sorted order. This clip is from the chapter "Collections" of the series "Java Programming for Complete Beginners - Java 16".In this section, we will explore Java collections -...
Curated Video
Java Programming for Complete Beginners - Java 16 - Step 02 - Java Arrays - Creating and Accessing Values – Introduction
In this session, we will learn about Java arrays - creating and accessing values – introduction. This clip is from the chapter "Arrays and ArrayLists" of the series "Java Programming for Complete Beginners - Java 16".In this section, we...
Curated Video
The Complete Java Developer Course: From Beginner to Master - 2D Arrays (Side Topic)
This video explains about the 2D arrays. This clip is from the chapter "Methods" of the series "The Complete Java Developer Course: From Beginner to Master".This section explains Methods that are a set of blocks of code that resolves a...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Offset Property
The Range.Offset property shifts the currently selected range to a new one. It accepts two arguments -- the number of rows and the number of columns to move. Positive arguments represent downward movements for rows and rightward...
Curated Video
Excel VBA Programming The Complete Guide - The Workbooks.Add Method
In this lesson, we invoke the Workbooks.Add method to create a new workbook from scratch. We also pass it an optional Template argument to make a copy of an existing workbook. This clip is from the chapter "Object Deep Dive" of the...
Curated Video
Excel VBA Programming The Complete Guide - Procedures with Arguments
Learn to handle arguments. This clip is from the chapter "Procedures" of the series "Excel VBA Programming–The Complete Guide".We look into variable scopes in procedures.
Curated Video
Excel VBA Programming The Complete Guide - Visual Basic Editor Options
The Visual Basic Editor includes a complex set of options that cover everything from syntactical help with the code to visual aesthetics. In this lesson, we'll explore all of the available options and configure a setup that is ideal for...
Curated Video
Excel VBA Programming The Complete Guide - The initialize Event
The initialize event shoots off before the UserForm is rendered. It can be used to calculate configure dynamic values. In this lesson, we create a new form that displays the current day of the week when it loads. This clip is from the...
Curated Video
Excel VBA Programming The Complete Guide - The Worksheet_SelectionChange Event
The Worksheet_SelectionChange event is triggered when the user navigates to a different cell with a spreadsheet. In this lesson, we react our first Excel event and also explore the ByVal keyword in the automatically generated procedure....
Curated Video
Excel VBA Programming The Complete Guide - Breakpoints
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. This clip is from the chapter "Debugging" of the series "Excel VBA...
Curated Video
Excel VBA Programming The Complete Guide - More Date and Time Functions
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...
Curated Video
Excel VBA Programming The Complete Guide - The MsgBox Method In Depth, Part I
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. This clip is from the chapter...
Curated Video
HTML CSS and JavaScript for Beginners - A Web Design Course - What is JSON
In this video, we'll cover what is JSON. 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 about JSON, JSON...
Curated Video
The Modern JavaScript Bootcamp (2019) - Sorting Arrays
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? This clip is from the...
Curated Video
Introduction to Arrays and Random Name Generator in Small Basic Programming
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 for...