04 Excel VBA Tools & Advanced Conditional Logic

Essential Tools & Advanced Conditional Logic

Intro to Essential Tools and ACL (Plus Download Kit)

Three Ways To Access Other Sheets - Sheet Name, Index and CodeName Sample Lesson

Get the Last Row of Your Data Set

Get the Last (Rightmost) Column of Your Data Set

Get the Next Row in Your Data Set - Data Entry Basics

Recording a Macro 101

Dynamically Sorting The Employee Data

Absolute vs Relative References and OFFSET() Function

R1C1 Notation and How To Use In Formulas

Using Worksheet Functions in the VBE

Random Password Generator Assignment

Random Password Generator Solution Video

Using With and End With

If Then Statement

Using Is Not Equal To And The NOT Operator

AND, OR and NOT Operators

Exercise 06a - Objectives Overview

Exercise 06a - Solution

Using ELSE and ELSEIF Commands

Rock, Paper, Scissors Game Project Breakdown

Rock, Paper, Scissors Game Solution

The LIKE Operator

Compare Strings With Case Insensitivity Using UCase and LCase

Comparitive Operators With Text and Numbers (IsNumeric Function)

Two Ways to Use If Then Statements in a One-Liner of Code

Using GOTO and Labels, Common Uses, Error Routing

Select Case as Alternative to IF THEN Statements

Advanced MessageBox Features

User Interaction - Message Box with Yes, No Buttons

Exercise 06b - Objectives Overview

Exercise 06b - Solution

User Defined Functions 101

User Defined Functions - Optional Parameters

Volatile vs Non-Volatile Functions

Essential Tools and ACL Quiz

06 - Super Important Info Quiz

BONUS Section - VBA Functions

InStr Function - Search for Text Within Other Text

The EVALUATE Function - Mac-Daddy of all functions

Sum Function in Excel VBA - EASY!

Count Function in VBA

Previous Lesson

Three Ways To Access Other Sheets - Sheet Name, Index and CodeName

04 Excel VBA Tools & Advanced Conditional Logic
Three Ways To Access Other Sheets - Sheet Name, Index and CodeName

Previous Lesson

Leave a Comment Click here to cancel reply.

You must be logged in to post a comment.

X

Username

Password

Remember me

Forgot Password?

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account