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
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
1 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
Next 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
Back to Course
Next Lesson
Post a comment

Leave a Comment

X

Forgot Password?

Join Us

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram