Curated Video
Excel VBA Programming The Complete Guide - Excel Worksheet Functions
Many of Excel's popular worksheet functions are available for use in the Visual Basic Editor. In this lesson, we implement the popular VLOOKUP function using code. This clip is from the chapter "Functions" of the series "Excel VBA...
Curated Video
Excel VBA Programming The Complete Guide - Macro Security
Macros have been used to package malicious code in the past. In this lesson, we explore the security options built into Excel that prevent macro code from executing automatically. We also add a directory to a Trusted Locations list of...
Curated Video
Excel VBA Programming The Complete Guide - Excel File Types
There are dozens of file types available in Excel. In order to work with macros, we need to save our files in a special format called .xlsm. In this lesson, we introduce an option for defaulting to a .xlsm format upon saving. This clip...
Curated Video
Learning Lodash 4.0 (Video 18)
Lodash was built to simplify JavaScript application development. It contains hundreds of methods built for the purpose of providing developers with a fast, reliable, cross-browser toolkit to write applications. With Lodash, you can...
Curated Video
Learning Lodash 4.0 (Video 17)
Lodash was built to simplify JavaScript application development. It contains hundreds of methods built for the purpose of providing developers with a fast, reliable, cross-browser toolkit to write applications. With Lodash, you can...
Programming Electronics Academy
Interrupt Cautions: Arduino Course 9.5
A highlight of things to consider when using interrupt service routines.
Packt
String Methods & Concatenation
JavaScript Language Fundamentals: String Methods & Concatenation 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...
Curated Video
Excel VBA Programming The Complete Guide - The Byte, Integer and Long Data Types
VBA has 3 options for whole numbers: Byte, Integer, and Long. Each data type supports a different range of numbers; Byte only supports any number from 0 to 256 while Long can store numbers in the billions. In this lesson, we practice...
Curated Video
Excel VBA Programming The Complete Guide - The Option Explicit Setting
The Option Explicit setting at the top of a code module mandates that all variables be declared with a valid data type before being assigned a value. In this lesson, we compare a code sample with and without this setting enabled to see...
Curated Video
Excel VBA Programming The Complete Guide - The TypeName Method
The VBA.TypeName method accepts an VBA object and returns its type as a string. In this lesson, we practice invoking the method in the Immediate Window with a variety of inputs including strings, numbers, and various Excel objects. This...
Curated Video
Excel VBA Programming The Complete Guide - Default Properties
In this lesson, we'll explore the default properties on the Range and Application objects and discuss the benefits and disadvantages of explicitly writing them out. This clip is from the chapter "The Fundamentals of the Excel Object...
Programming Electronics Academy
Another Interrupt Example: Arduino Course 9.4
An example of using an interrupt service routine with Arduino.
Curated Video
Hands-On WebAssembly for C++ Programmers - Passing Complex Data with Embind
So far, we can pass primitive types only. How do we pass objects, enumerations, and more? • Learn how to pass enumerations • Learn how to pass value objects • Learn how to pass classes This clip is from the chapter "Running Our First C++...
Curated Video
Learn and Master C Programming - Working with single-dimension arrays in C/C++
We will see how we can declare and process a single-dimensional array in C/C++. This clip is from the chapter "Arrays" of the series "Learn and Master C Programming For Absolute Beginners!".In this section, we will look at how to declare...
Curated Video
Complete Java SE 8 Developer Bootcamp - Loops
Conditionals are one type of control structure. Another type allows us to continuously execute a block of a code while a condition is true. This clip is from the chapter "Java Syntax" of the series "Complete Java SE 8 Developer...
Curated Video
Excel VBA Programming The Complete Guide - The Value vs. Text Properties
Sometimes, the way data is presented in the Excel interface is not the same way it is stored internally. In this lesson, we explore the Value and Text properties on the Range object. The former returns the actual data value while the...
Curated Video
Excel VBA Programming The Complete Guide - The Single and Double Data Types
The Single and Double data types represent a floating point number or, in other words, a number with a fractional or decimal component. We discuss the advantages of the Double data type and use it in a procedure that calculates a...
Curated Video
Excel VBA Programming The Complete Guide - Methods with Multiple Arguments
Some object methods can accept multiple arguments. In this lesson, we continue exploring the Workbooks.Open method and two of its parameters -- FileName and ReadOnly. Arguments can be fed in sequentially or with named parameters -- both...
Curated Video
Excel VBA Programming The Complete Guide - Methods without Arguments
In this lesson, we'll explore three methods: • The Workbooks.Add method to create a new Workbook • The Workbook.Save method to save a single Workbook. • The Range.Clear method to clear a range of values, styling and formats. This clip is...
Curated Video
Learning Lodash 4.0 (Video 21)
Lodash was built to simplify JavaScript application development. It contains hundreds of methods built for the purpose of providing developers with a fast, reliable, cross-browser toolkit to write applications. With Lodash, you can...
Curated Video
Learning Lodash 4.0 (Video 14)
Lodash was built to simplify JavaScript application development. It contains hundreds of methods built for the purpose of providing developers with a fast, reliable, cross-browser toolkit to write applications. With Lodash, you can...