About
LearnDesk
Learn  
Topics
Topics
Topics
Topics
Topics
Topics
Topics
Teach
  Teach Online
  Schedule
  Items
  Billing
  Users
  Marketing
  Analytics
  Settings
  Change School
Account
 

Excel VBA for Beginners

1-Introducing Excel VBA (Visual Basic for Applications)
Course Promo
Preview
Course Example & Exercise Files
Introduction & Know your Instructor
Recording Macros vs Writing VBA code
Understanding Objects
Understanding the VBA Syntax
Recording a Basic Macro
Absolute vs Relative Macro Recording
Activating the Developer Tab
2- The Visual Basic Editor
Introduction to the Visual Basic Editor(VBE)
The Project Explorer
The Properties Window
The Code Window
Immediate, Local and Watch Windows
Dealing with Modules
3- The Range object - Dealing with cells
Introduction and changing cell values
Adding a text to a cell
Dealing with Named Ranges
Value vs Text Properties
Row & Columns Properties
The Select Method
The Count Property
The Address Property
The Formula Property
Number Format Property
The Font Property
4-The Cells Collection object for dealing with Cells
What is the cells object?
Affecting cells positionally within a range
Affecting all cells within a sheet
Combining Range and cells object
5- Dealing with Worksheets
Selecting Sheets
Adding Sheets
Sheets vs Worksheets
Copying Sheets
Moving Sheets
Deleting Sheets
6- Variables
Variables intro
Variable Data Types
Declaring Variables
Object Variables
Calling a procedure from another procedure
Public and Private Variables
Declaring Constants
7- Dealing with Workbooks
Referring to workbooks
Closing Workbooks
Adding and Saving Workbooks - Part 1
Adding and Saving Workbooks - Part 2
Opening Workbooks
8- Must know Excel Logic
Finding the Last Row
Finding the last column
Finding the next row
The With Statement
Comparison operators in Excel VBA
GOTO Statement and Labels
IF Statements - Part 1 - Simple IF Statements
IF Statements Part 2- IF THEN ELSE Structure
IF Statements Part 3 - IF THEN ELSEIF Structure
IF Statements Part 4 - Nested IF Statements
IF Statements - Exercise
OR / AND Logical Operators
NOT Logical Operator
Case Statements Part 1 - Single Case Statements
Case Statements Part 2 - Nested Case Statements
Case Statements- Exercise
9- Loops
Introduction to Loops
FOR NEXT Loop
EXIT FOR Statement
FOR NEXT Loop - Exercise
FOR EACH Loop Part 1 - Introduction and looping through worksheets in a collection
FOR EACH Loop Part 2 - More examples of FOR EACH
FOR EACH Loop - Exercise
DO Loop - Introduction
DO Loop - Simple Example
DO UNTIL with Example
DO WHILE with Example
DO WHILE vs DO UNTIL - Movies Example
Exit Do Statement
DO Loop - Exercise
10 - Interacting with users
Message Box - Introduction
Message Box - Inputs
Message Box - Capturing User's Input
Message Box - Exercise
Adding a New Line to VBA Strings
Input box - Introduction
Input Box - Capturing a User's Name
Input Box - Employee Database Example - Part 1
Input Box - Employee Database Example - Part 2
Input Box - Exercise
11- Error Handling
Error Handling - Introduction
Different Types of Errors in action
On Error resume Next
On Error GO TO Statement
Resetting the error handling status - ON Error GO TO 0
The Err Object
Setting a breakpoint on your code
Events in Excel VBA
Worksheet Events - Worksheet Selection Change Event
Worksheet Events -Worksheet activate Event
Worksheet Events - Worksheet de-activate event
Worksheet Events - Worksheet Before delete event
Worksheet Events - Before Double Click Event
Worksheet Events - Before Right Click Event
Worksheet Events - Worksheet Calculate Event
Enabling and Disabling Events
Worksheet Events - Worksheet Change Event
Worksheet Events - Follow Hyperlink Event
Worksheet Events - Exercise
Workbook Events - Workbook Open Event
Workbook Events - Workbook Activate Event
Workbook Events - Workbook BeforeSave Event
Workbook Events - Workbook After Save event
Workbook Events - Workbook Before Close event
Workbook Events - Workbook Before Print event
Workbook Events - Workbook de-activate event
Workbook Events - Workbook New Chart event
Workbook Events - Workbook New Sheet event
Workbook Events - Workbook Sheet Calculate event
Workbook Events - Workbook Sheet de-activate event
Workbook Events - Workbook HyperLink Event
Workbook Events - Workbook Window Activate event
Workbook Events - Workbook Window de-activate event
Workbook Events - Workbook Window resize event
Workbook Events - Exercise

4-The Cells Collection object for dealing with Cells

Excel VBA for Beginners
By: Abdelrahman Abdou
Share the link to this page
Copied
  Twitter
  Email
Add the class to your calendar
Print
  Completed
In this section, we take a look at the cells collection object which is another way of dealing with cells in Excel VBA.
We'll cover the following topics in this section:
Previous
Next
Home
Search
Saved
Trending Classes
Filter
The latest and the best classes on LearnDesk
Filter by Interest
Close
All Topics
Academics
Business
Creative
Health and Fitness
LifeStyle
Personal Development
Software
Admissions
Engineering
Hardware
Hospitality
Humanities
Chinese
Languages
Maths
Other
Pharma
Research
Science
Social Science
Teaching
Test Preparation
K-12
School
Accounting
Advertising
Analysis
Analytics
Business Communication
eCommerce
Entrepreneurship
Finance
Finance - India
Freelancing
Internet of Things
Digital Transformation
Human Resources
Industry
Management
Marketing
Media
Operations
Other
Project Management
Public Relations
Real Estate
Sales
Strategy
Arts & Crafts
Audio Editing
Audio Production
Dance
Design
Film Production
Music
Photography
Video Production
Writing
Dieting
Fitness
Food Safety
Games
Medical
Medical Professionals
Meditation
Mental Health
Pregnancy
Safety & First Aid
Self Defense
Sports
Beauty & Makeup
Food
Fashion
Gaming
Home Improvement
Parenting
Pet Care & Training
Relationships
Sustainable Living
Travel
Career Development
Learning
Religion and Spirituality
Self-Improvement
Accounting
Amazon Web Services
App Development
Continuous Integration
Backup Software
Business Automation
Computational Fluid Dynamics
Business Intelligence
Computer Aided Design (CAD)
Content Management System
Customer Relationship Management
Database
Data Mining
E-Commerce
Enterprise Asset Management
Enterprise Resource Planning
Game Development
Google Cloud
Linux
Artificial Intelligence
Machine Learning
Master Data Management
Microsoft
Music Software
Network and Security
Open Source
Operating System
Other
Process Management
Productivity Software
Programming Languages
Robotics
Supply Chain Management
Testing
Teaching
Web Development

Sign Up

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.