Curated Video
Excel VBA Programming The Complete Guide - The Parent Property on All Objects
Coming full circle, we navigate from a Range object all to the way to the top of the Excel object model (the Application object) by relying on each object's Parent property. The property returns the object enclosing the current one. This...
Curated Video
Excel VBA Programming The Complete Guide - The String Data Type
A string is a collection of characters --- in layman's terms, it's just text. In this lesson, we take a look at VBA's support for two types of strings -- variable-length and fixed-length -- as well as the advantages of both. This clip is...
Curated Video
Excel VBA Programming The Complete Guide - Activate a UserForm from Procedure
The more we can abstract away the complexity of VBA from the regular Excel user, the better. In this lesson, we set up a graphic on our Excel interface to trigger the UserForm to appear. This clip is from the chapter "User Forms" of the...
Curated Video
Excel VBA Programming The Complete Guide - Workbook Events and The Sh Argument
The Workbook event has its own set of event procedures. One common trend in their signatures is the presence of a Sh argument, which represents the sheet on which the event has been triggered. In this lesson, we construct a dynamic macro...
Curated Video
Excel VBA Programming The Complete Guide - Review of Application.EnableEvents
The Application.EnableEvents property is used to enable and disable Excel events (automatic actions that are triggered by user interactions). In this lesson, we discuss the benefits of temporarily disabling this feature in an event...
Curated Video
Excel VBA Programming The Complete Guide - Intro to Arrays
In this section, we'll explore the array, the most popular data structure in computer science. An array is a sequenced collection of elements, each of which is assigned an index position. In this lesson, we create a fixed-size array of...
Curated Video
Excel VBA Programming The Complete Guide - The Visual Basic Editor
In this lesson, we explore the components of the Visual Basic Editor, including the Project Explorer, which lists all open workbooks and worksheets as well as all modules (containers for code). Properties Window, which can be used to get...
Curated Video
Excel VBA Programming The Complete Guide - StatusBar
The StatusBar is an information bar located on the bottom left of the Excel interface. In this lesson, we run a long procedure and use the StatusBar to provide updates to the user on its completion status. This clip is from the chapter...
IDG TECHtalk
Using Cython to speed up Python
Cython allows math-heavy Python code to be transformed into C and run at many times its original speed. Here, we'll demonstrate graphically how this works.
Curated Video
Bash Shell Scripting- For loop with arrays
This video shows how to use the for loop with arrays. This clip is from the chapter "Loops and Loop control statements - Part 1" of the series "Complete Bash Shell Scripting".This section is the first part that explains Loops and Loop...
Curated Video
Bash Shell Scripting- Introduction to Arrays
This video introduces you to arrays. This clip is from the chapter "Arrays of bash shell scripting" of the series "Complete Bash Shell Scripting".This section covers the arrays of Bash shell scripting.
Packt
General Loops
JavaScript Language Fundamentals: General Loops This clip is from the chapter "JavaScript Language Fundamentals" of the series "Modern JavaScript from the Beginning".In this section, you will learn the important fundamentals and concepts...
Curated Video
Complete Modern C++ - Non-type Template Arguments
This video explains the purpose of non-type template arguments. This clip is from the chapter "Templates" of the series "Complete Modern C++".In this section, we will see non-type template arguments, perfect forwarding, variadic...
Curated Video
Comprehensive Android Developer Bootcamp - Pre-setting Arrays' Length
Java Data Structures:Pre-setting Arrays' Length This clip is from the chapter "Java Data Structures" of the series "The Comprehensive Android Developer Bootcamp".In this section you will cover the Java Data Structures. You will be...
Curated Video
Complete Java SE 8 Developer Bootcamp - Sorting and Searching Collections
Learn how collections can be sorted and searched through, with methods provided by the Collections class. This clip is from the chapter "More with Collections" of the series "Complete Java SE 8 Developer Bootcamp".In this section, learn...
Curated Video
Java Programming for Complete Beginners - Java 16 - Step 03 - Java Arrays - Puzzles - Arrays of Objects, Primitive Data Types, toStr
In this session, we will learn about Java arrays - puzzles - arrays of objects, primitive data types, toStr. This clip is from the chapter "Arrays and ArrayLists" of the series "Java Programming for Complete Beginners - Java 16".In this...
Curated Video
HTML CSS and JavaScript for Beginners - A Web Design Course - Array Methods
In this video, we'll cover array methods. 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, JavaScript code, functions,...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Sort Method
Sorting is one of the most popular operations in Excel. In this lesson, we utilize the Range.Sort method to sort both one and two columns at a time (in ascending or descending order) and discuss how we can ignore the values in the header...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Delete Method
Most deletion operations will involve removing entire rows or columns at a time. In this lesson, we discuss how to make that happen in VBA as well as what happens when we delete a single cell instead. This clip is from the chapter "Range...
Curated Video
Excel VBA Programming The Complete Guide - R1C1 Notation, Part I
R1C1 notation is a different way of thinking about cells in Excel. Instead of using a letter for the column and a row for the number, R1C1 relies on numbers for both. In this lesson, we enable R1C1 notation in our Excel interface and...
Curated Video
Excel VBA Programming The Complete Guide - The Worksheet.Visible Property
The Worksheet.Visible property is used to hide and unhide a worksheet. It accepts either a Boolean argument (True or False) or an XlSheetVisibility enumeration. One cool VBA feature is the ability to use the xlSheetVeryHidden option to...
Curated Video
Excel VBA Programming The Complete Guide - The Variant Data Type
In this lesson, we use the TypeName method from the VBA object to track the data type of a Variant variable as we assign different values to it. This clip is from the chapter "Variables and Data Types" of the series "Excel VBA...
Curated Video
Excel VBA Programming The Complete Guide - Ways to Invoke A Procedure
In this lesson, we explore a myriad of ways to execute a public procedure from both the code editor and the Excel interface, including: • The green execute button in the VBE • The F5 keyboard shortcut in the VBE • Clickable buttons • The...
Curated Video
Excel VBA Programming The Complete Guide - The MsgBox Method
The MsgBox is a simple dialog box that prompts a user action or confirmation. In this lesson, we'll explore the syntax for the method as well as begin our discussion of inputs, parameters, and arguments. A parameter is the name given to...