About
About Us
Help
Privacy Policy
Terms of Service
LearnDesk
Learn
Academics
Business
Creative
Health and Fitness
Lifestyle
Personal Development
Software
Topics
Admissions
Engineering
Hardware
Hospitality
Humanities
Chinese
Languages
Maths
Pharma
View All Topics
Topics
Accounting
Advertising
Analysis
Analytics
Business Communication
eCommerce
Entrepreneurship
Finance
Finance - India
Freelancing
View All Topics
Topics
Arts & Crafts
Audio Editing
Audio Production
Dance
Design
Film Production
Music
Photography
Video Production
Writing
View All Topics
Topics
Dieting
Fitness
Food Safety
Games
Medical
Medical Professionals
Meditation
Mental Health
Pregnancy
Safety & First Aid
View All Topics
Topics
Beauty & Makeup
Food
Fashion
Gaming
Home Improvement
Parenting
Pet Care & Training
Relationships
Sustainable Living
View All Topics
Topics
Career Development
Learning
Religion and Spirituality
Self-Improvement
View All Topics
Topics
Accounting
Amazon Web Services
App Development
Continuous Integration
Backup Software
Business Automation
Computational Fluid Dynamics
Business Intelligence
Computer Aided Design (CAD)
View All Topics
Teach
Teach Online
Schedule
Items
Billing
Users
Marketing
Analytics
Settings
Change School
Account
Log In
Sign Up
Advanced Excel VBA Crash Course
Introduction-1
Why learn Macros?
Preview
Activate "Developer" tab
Preview
Saving a Macro-enabled WorkBook (XLSM)
Macro Security Settings
Developer tab - Essential Buttons
Head & Tail of a Macros (Sub Procedure & User Defined Function)
"Click Here" button to run a Macro
Downloadable Working files
Practice Files
INTRODUCTION 2
Macros - Record & Run
Preview
Macros - Viewing the code
Macro-free vs. Macro-enabled Workbook
Visual Basic Editor (VBE)
Personal Macro WB
Ways to Run a Macro
GOOGLE
Using Google to locate useful VBA codes – 1
Using VBE and Macro Recorder to customize Macro code
Using Google to locate useful VBA codes – 2
OBJECTS, PROPERTIES, METHODS
Objects, Properties, Values, Methods and Parameters 1
Objects, Properties, Values, Methods and Parameters 2
WORKSPACE
Code Color & Activating Edit Toolbar w. Comments
Edit Toolbar - Indent, Bookmark
Code writing shortcuts incl. Intellisense
Testing the Code
Immediate Window 01
RANGE & CELLS OBJECT
Range Selection - Method 1
Range Selection - Method 2 & 3
Advantage of Range Selection - Method 2 & 3
Range Selection (Rows & Columns) - Method 4
Assigning values to selected range of cells
Exercise 1 - Assigning values to selected range of cells
Exercise 2- Assigning values to selected range of cells
Multiple Range Selection - Method 5
Multiple Range Selection - Method 6
Range Selection Ways – Others
ABSOLUTE vs RELATIVE REFERENCE
Offset – Basics
Using Relative Reference in Macros
RANGE NAVIGATION
Navigating between a range of cells - Part 1
Navigating between a range of cells - Part 2
Navigating between a range of cells - Part 3
Exercise - Finding Last Row No.
Exercise - Finding Last Column No.
Exercise - Finding Next Row No.
VARIABLE DECLARATION
Variable Decl 01
Variable Decl 02
Pvt vs Public 01
Pvt vs Public 02
Option Explicit
Difference - DIM vs. SET
LOOPS
"For...Next"
"If...Else...End If" nested within "For...Next"
"Do…While"
"Do…Until"
"For Each...Next"
"If...End If" nested within "For Each...Next"
Exercise - "Do While" and Loop Counter
"With…End With" - Example 1
"With…End With" - Example 2
"Select…Case" – Demonstration
"Select…Case" – Explanation
OPTIMIZING CODE EFFICIENCY
Speed up the code running – 1
Speed up the code running – 2
Speed up the code running – 3
EVENTS
Introduction
Events - Workbook Open and Worksheet Activate
Exercise 1 - Tracking Workbook Opens
Exercise 2 - Tracking Workbook Save
Event - Worksheet Before Double Click
Event - Worksheet Change
Event - Worksheet Calculate
Pivot Table - Refresh - Work Sheet Activate
INPUT BOX
Introduction
Input Box – 1
Input Box – 2
Input Box – 3
Input Box – 4
MSG BOX
Introduction to Msg box in excel vba
MsgBox – 1
MsgBox – 2
MsgBox – 3
MsgBox – 4
ACTIVEX CONTROLS
Form Controls vs ActiveX Controls
MouseMove Event w. Appln Statusbar
USER FORMS
Introduction
User Form – Basics
Exercise - Part 1 of 4
Exercise - Part 2 of 4
Exercise - Part 3 of 4
Exercise - Part 4 of 4
Option Button – 1
Option Button – 2
Multi Page – Introduction
Multi Page – 1
Multi Page – 2
Multi Page – 3
Check Box 01
Combo Box - Method 1
Combo Box - Method 2
USER DEFINED FUNCTIONS
UDF Intro 01
UDF Example 1 - ScoreResult with IF END IF
UDF Example 2 – CellComments
UDF Samples - Series A
UDF Samples - Series B
MIS PROJECTS
Split Workbook
Protect - Unprotect Sheets
Index of Hyperlinks to all Sheets
Extract all Comments of a WorkBook to a new WorkSheet
Project- Automate,Comment,Insertion and Extraction
Count Cells by Color
Combine WorkSheets
Using Relative Reference in Macros
Advanced Excel VBA Crash Course
ABSOLUTE vs RELATIVE REFERENCE
By:
Yoda Learning
3 minutes
Share
Share the link to this page
Copied
Facebook
Twitter
WhatsApp
LinkedIn
Email
Add to Calendar
Add the class to your calendar
Add to Google Calendar
Add to Apple Calendar
Add to Yahoo Calendar
Add to Outlook Calendar
Print
Completed
You need to have access to the item to view this lesson.
One-time Fee
$69.99
List Price:
$99.99
You save:
$30
Buy Class
€67.35
List Price:
€96.21
You save:
€28.86
Buy Class
£55.83
List Price:
£79.77
You save:
£23.93
Buy Class
CA$100.76
List Price:
CA$143.95
You save:
CA$43.19
Buy Class
A$112.23
List Price:
A$160.33
You save:
A$48.10
Buy Class
S$95.14
List Price:
S$135.93
You save:
S$40.78
Buy Class
HK$543.62
List Price:
HK$776.63
You save:
HK$233.01
Buy Class
CHF 63.04
List Price:
CHF 90.06
You save:
CHF 27.02
Buy Class
NOK kr797.48
List Price:
NOK kr1,139.30
You save:
NOK kr341.82
Buy Class
DKK kr502.49
List Price:
DKK kr717.87
You save:
DKK kr215.38
Buy Class
NZ$124.10
List Price:
NZ$177.29
You save:
NZ$53.19
Buy Class
د.إ257.07
List Price:
د.إ367.26
You save:
د.إ110.18
Buy Class
৳8,361.55
List Price:
৳11,945.58
You save:
৳3,584.03
Buy Class
₹5,962.79
List Price:
₹8,518.63
You save:
₹2,555.84
Buy Class
RM314.04
List Price:
RM448.65
You save:
RM134.61
Buy Class
₦108,335.42
List Price:
₦154,771.52
You save:
₦46,436.10
Buy Class
₨19,495.71
List Price:
₨27,852.21
You save:
₨8,356.49
Buy Class
฿2,390.81
List Price:
฿3,415.60
You save:
฿1,024.78
Buy Class
₺2,467.44
List Price:
₺3,525.07
You save:
₺1,057.62
Buy Class
B$434.14
List Price:
B$620.23
You save:
B$186.09
Buy Class
R1,296.68
List Price:
R1,852.48
You save:
R555.80
Buy Class
Лв131.68
List Price:
Лв188.12
You save:
Лв56.44
Buy Class
₩102,198.93
List Price:
₩146,004.73
You save:
₩43,805.79
Buy Class
₪256.56
List Price:
₪366.53
You save:
₪109.97
Buy Class
₱4,090.81
List Price:
₱5,844.26
You save:
₱1,753.45
Buy Class
¥10,994.99
List Price:
¥15,707.80
You save:
¥4,712.81
Buy Class
MX$1,408.98
List Price:
MX$2,012.91
You save:
MX$603.93
Buy Class
QR255.09
List Price:
QR364.43
You save:
QR109.34
Buy Class
P967.82
List Price:
P1,382.66
You save:
P414.84
Buy Class
KSh9,046.20
List Price:
KSh12,923.70
You save:
KSh3,877.50
Buy Class
E£3,562.49
List Price:
E£5,089.49
You save:
E£1,527
Buy Class
ብር8,907.19
List Price:
ብር12,725.10
You save:
ብር3,817.91
Buy Class
Kz63,830.88
List Price:
Kz91,190.88
You save:
Kz27,360
Buy Class
CLP$69,323.69
List Price:
CLP$99,038.09
You save:
CLP$29,714.40
Buy Class
CN¥510.80
List Price:
CN¥729.75
You save:
CN¥218.94
Buy Class
RD$4,245.36
List Price:
RD$6,065.06
You save:
RD$1,819.70
Buy Class
DA9,465.07
List Price:
DA13,522.10
You save:
DA4,057.03
Buy Class
FJ$162.39
List Price:
FJ$232
You save:
FJ$69.60
Buy Class
Q539.11
List Price:
Q770.19
You save:
Q231.08
Buy Class
GY$14,638.77
List Price:
GY$20,913.42
You save:
GY$6,274.65
Buy Class
ISK kr9,772.70
List Price:
ISK kr13,961.60
You save:
ISK kr4,188.90
Buy Class
DH703.98
List Price:
DH1,005.73
You save:
DH301.75
Buy Class
L1,291.33
List Price:
L1,844.84
You save:
L553.50
Buy Class
ден4,143.97
List Price:
ден5,920.21
You save:
ден1,776.24
Buy Class
MOP$559.97
List Price:
MOP$800
You save:
MOP$240.02
Buy Class
N$1,289.45
List Price:
N$1,842.15
You save:
N$552.70
Buy Class
C$2,574.80
List Price:
C$3,678.44
You save:
C$1,103.64
Buy Class
रु9,534.71
List Price:
रु13,621.60
You save:
रु4,086.89
Buy Class
S/260.99
List Price:
S/372.86
You save:
S/111.86
Buy Class
K283.85
List Price:
K405.52
You save:
K121.66
Buy Class
SAR262.91
List Price:
SAR375.60
You save:
SAR112.69
Buy Class
ZK1,936.45
List Price:
ZK2,766.47
You save:
ZK830.02
Buy Class
L335.12
List Price:
L478.77
You save:
L143.64
Buy Class
Kč1,694.03
List Price:
Kč2,420.15
You save:
Kč726.12
Buy Class
Ft27,771.44
List Price:
Ft39,675.18
You save:
Ft11,903.74
Buy Class
SEK kr774.38
List Price:
SEK kr1,106.30
You save:
SEK kr331.92
Buy Class
ARS$71,792.58
List Price:
ARS$102,565.23
You save:
ARS$30,772.64
Buy Class
Bs484.55
List Price:
Bs692.24
You save:
Bs207.69
Buy Class
COP$307,165.41
List Price:
COP$438,826.54
You save:
COP$131,661.12
Buy Class
₡35,530.54
List Price:
₡50,760.09
You save:
₡15,229.55
Buy Class
L1,777.33
List Price:
L2,539.15
You save:
L761.82
Buy Class
₲546,250
List Price:
₲780,390.60
You save:
₲234,140.59
Buy Class
$U3,115.91
List Price:
$U4,451.49
You save:
$U1,335.58
Buy Class
zł287.82
List Price:
zł411.19
You save:
zł123.37
Buy Class
Already have an account?
Log In
Previous
Next
Sign Up
Signup to access thousands of classes
Continue with Facebook
Continue with Google
OR
Continue with Email
Already a member?
Log In
By registering for a LearnDesk account, you agree to our
Terms of Service
and
Privacy Policy
.
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.
Share with Google Contacts