Differentiate between public vs private procedure.<br/<br/>>

This clip is from the chapter "Procedures" of the series "Excel VBA Programming–The Complete Guide".We look into variable scopes in procedures.

In this lesson, we explore one of VBA's coolest features -- defining public custom functions that appear directly in the Excel interface.We dive into the syntax for declaring the function, identifying its expected arguments, and...

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

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.
r/>
This clip is from the chapter "User...

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

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

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

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.
r/>
This clip is from...

In this video, we will explore what accounts receivable are and dive into the purpose and process of conducting accounts receivable confirmations during an audit. We will also discuss the different types of confirmations and their impact...

An event is a regular Excel action --- opening a worksheet, entering a cell value -- that can automatically trigger a VBA procedure. In this lesson, we compare event procedures to regular procedures and setup our VBE environment for...

Programmers of all experience levels make mistakes --- it's part of the job. Error handling is the ability to avoid errors in our code by catching them before they happen. In this lesson, we discuss some common errors we can run into...

Individuals subject to administrative regulations will often challenge the determinations made by the Administrative Courts within the administrative agency enforcing the regulations. They do this in a traditional or Article III court....

In this video, the teacher explains the procedure for issuing debentures and how it is accounted for. The video covers the steps of issuing debentures, including inviting applications, issuing letters of allotment, and refunding money on...

Science is always progressing at an astronomical rate, but are we going too far? Are we starting to play God? Where do we draw the line? Here's our list of 10 Times Science Played God'

A daring surgery aims to put a part of a baby's brain, which was growing outside of his skull, back where it belongs.

In this lesson, we explore constants, an alternative to variables. A constant's value cannot change over the course of a macro's execution, making it optimal for static values.
r/>
This clip is from the chapter "Procedures" of...

In this lesson, we practice declaring several dates and times in our procedure and outputting them to the spreadsheet.
r/>
This clip is from the chapter "Variables and Data Types" of the series "Excel VBA Programming–The...

Some errors are not catastrophic to the health of a procedure --- some, in fact, are completely ignorable. In this lesson, we utilize the On Error Resume Next keywords to tell an iteration macro to continue in spite of any errors...

This video explains the accounting procedure for the dissolution of a partnership firm, including the preparation of ledger accounts such as realization account, capital account, and cash in bank account. The video covers various...

In this lesson, we introduce a basic sum example to show how R1C1 notation can be helpful when duplicating formulas across multiple columns.
r/>
This clip is from the chapter "Range References" of the series "Excel VBA...

The Worksheet.Delete method removes a worksheet. It is particularly effective to temporarily disable alerts before invoking this method to make the process as smooth and seamless for the user as possible.
r/>
This clip is from...

In this lesson, we explore the syntax for declaring a variable and its data type, as well as assigning it an initial value with the assignment operator ( = ).
r/>
This clip is from the chapter "Variables and Data Types" of the...

The For loop is a fundamental building block of programming. It allows us to iterate, or to repeat a certain block of instructions a given number of times. In this lesson, we explore the syntax for For loops and implement a few...

In this video, we'll learn how to add stored procedure for cover type.
r/>
This clip is from the chapter "Cover Type CRUD" of the series "The Complete Guide to ASP.NET Core MVC (.NET 5)".In this section, let's look at cover...