01 Excel VBA 101: Read and Write Cell Data with Range & Cells Objects

The Range Object
Intro and Course Files Download
Get The Developer Ribbon (PC and Mac)
What Is The Range Object and Your First Macro From Scratch
Adding Secondary or Subsequent Commands
Debugging in Excel VBA and Stepping Through Code
Three Easy Ways To Test Or Store A Value
How and When To Record a Macro (Plus Clean Up Tips)
Three Main Data Type Notations For Entering Into Cells
Several Ways of Triggering Macros (Intro To Buttons and Fun Controls)
Exercise 01 - Objectives Overview
Exercise 01 - Solution
Affecting Multiple Cells With One Range Command
Using A Named Range With The Range Object
Tips and Best Practices For Better Development Skills
Range Object Quiz
1 Quiz
01 - Range Object Quiz
Range Properties
VALUE, TEXT and FORMULA Properties - Reading and Writing Functions To a Cell
Row and Column Properties
SELECT Method
COUNT Property
Exercise 02a - Objectives Overview
Exercise 02a - Solution
ADDRESS Property
NUMBERFORMAT Property
FONT Collection - BOLD, ITALIC, UNDERLINE Properties
Exercise 02b - Objectives Overview
Exercise 02b - Solution
Add Color To Cells, Inside and Out (4 Ways)
Range Properties Quiz
1 Quiz
02 - Range Properties Quiz
The Cells Object
Intro To The Cells Object
Using The Cells Object and Practical Applications
Using Column Letters Instead of Numbers
Using Cells Positionally Within A Range
Affecting ALL Cells In A Worksheet
Exercise 03 - Objectives Overview
Exercise 03 - Solution
Using Range Object With Cells Object (To Affect Multiple Cells)
Cells Object Quiz
1 Quiz
03 - Cells Quiz
Previous Lesson
Next Lesson

Get The Developer Ribbon (PC and Mac)

01 Excel VBA 101: Read and Write Cell Data with Range & Cells Objects Get The Developer Ribbon (PC and Mac)

Previous Lesson
Back to Course
Next Lesson
Post a comment

Leave a Comment

X

Forgot Password?

Join Us