Curated Video
Excel VBA Programming The Complete Guide - Syntax Tips
In this lesson, we'll explore some tips for writing cleaner and more elegant VBA code. This clip is from the chapter "Variables and Data Types" of the series "Excel VBA Programming–The Complete Guide".In this section, we work with...
Curated Video
Excel VBA Programming The Complete Guide - Comments
In this lesson, we'll explore the benefits of comments to the developer and practice writing them in the context of a procedure. This clip is from the chapter "The Visual Basic Editor" of the series "Excel VBA Programming–The Complete...
Curated Video
Excel VBA Programming The Complete Guide - Create and Delete a Procedure
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 declare...
Curated Video
Excel VBA Programming The Complete Guide - Design Aesthetics
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. This clip is from the chapter...
Curated Video
Excel VBA Programming The Complete Guide - The Label and TextBox Controls
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. This clip is from the chapter "User...
Curated Video
Excel VBA Programming The Complete Guide - Create UserForm, Toolbox, Properties, Controls
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. This clip is from...
Curated Video
Excel VBA Programming The Complete Guide - The Worksheet_Change Event
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...
Curated Video
Excel VBA Programming The Complete Guide - Deleting Rows
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) to...
Curated Video
Excel VBA Programming The Complete Guide - The With-End With Construct
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. This clip is...
Curated Video
Excel VBA Programming The Complete Guide - Boolean Expressions
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. This clip is from the...
Curated Video
Java Programming for Complete Beginners - Java 16 - Step 05 - Java Arrays - Exercise - Create Student Class - Part 1 - Total and Ave
In this session, we will learn about Java arrays - Exercise - Create Student Class - Part 1 - Total and Ave. This clip is from the chapter "Arrays and ArrayLists" of the series "Java Programming for Complete Beginners - Java 16".In this...
Curated Video
Frontend Web Development Bootcamp - Build a Twitter Clone - Objects
JavaScript Crash Course: Objects This clip is from the chapter "JavaScript Crash Course" of the series "Frontend Web Development Bootcamp: Build a Twitter Clone".This section is about JavaScript, Variables in JavaScript, Data types,...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Worksheet Property
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...
Curated Video
Excel VBA Programming The Complete Guide - The Paste and PasteSpecial Methods on the Worksheet Object
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. This clip is...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Copy and Range.Cut Methods
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. This clip is from the chapter "Range Actions" of the series "Excel...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Clear, Range.ClearContents and Range.ClearFormats Methods
In this quick lesson, we dive into 3 total methods on a Range object: • ClearContents, which removes the value from a Range. • ClearFormats, which removes the formatting of a cell (font, border, background, etc) • Clear, which removes...
Curated Video
Excel VBA Programming The Complete Guide - The Cells Property
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. This clip is from the chapter "Range References" of the series...
Curated Video
Finding the Area of a Rectangle: Making Connections with Arrays
In this video, students learn how to find the area of a rectangle by connecting it to arrays. They understand that area is the space inside a closed shape and can be found by counting the square units that fit inside it.
Curated Video
Beginning Python (Video 16)
Python is the becoming the language of choice for pretty much every arena. It is a very simple yet extremely powerful programming language. It is a scripting language that is widely used for prototyping to get work up and running in a...
Curated Video
C++ Standard Template Library in Practice - Understanding Containers
The user is unfamiliar with what containers are available and how they are used. • Begin by introducing the user to the different categories of containers • Familiarize the user with the abilities that each container has at a high level...
Curated Video
Excel VBA Programming The Complete Guide - The Range.End Property
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. This clip is from the chapter "Range References" of the...
Curated Video
Excel VBA Programming The Complete Guide - Access Object from Collection by Name
In this lesson, we explore this with the context of Worksheet objects inside the Worksheets collection. This clip is from the chapter "The Fundamentals of the Excel Object Model" of the series "Excel VBA Programming–The Complete...
Curated Video
Excel VBA Programming The Complete Guide - Stepping Through Code
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. This clip is from the chapter "Debugging" of the...
Curated Video
Excel VBA Programming The Complete Guide - VBA Functions, Part II
In this lesson, we explore 5 additional utility functions available in the Visual Basic Editor: • Left for pulling out characters from the beginning of a string • Right for pulling out characters from the end of a string • Mid for...