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.

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

Introduction to Msg box in excel vba

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

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

Variable Decl 02

Advanced Excel VBA Crash Course VARIABLE DECLARATION

By: Yoda Learning

2 minutes

Share the link to this page

Copied

Facebook

Twitter

Add the class to your calendar

Add to Google Calendar

Add to Apple Calendar

Add to Yahoo Calendar

Add to Outlook Calendar

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

€67.28

List Price: €96.12

You save: €28.84

£55.93

List Price: £79.91

You save: £23.97

CA$98.01

List Price: CA$140.02

You save: CA$42.01

A$107.87

List Price: A$154.11

You save: A$46.23

S$94.42

List Price: S$134.90

You save: S$40.47

HK$544.78

List Price: HK$778.29

You save: HK$233.51

CHF 62.22

List Price: CHF 88.89

You save: CHF 26.67

NOK kr779.46

List Price: NOK kr1,113.56

You save: NOK kr334.10

DKK kr501.79

List Price: DKK kr716.88

You save: DKK kr215.08

NZ$119.98

List Price: NZ$171.41

You save: NZ$51.43

د.إ257.07

List Price: د.إ367.26

You save: د.إ110.18

৳8,402.58

List Price: ৳12,004.20

You save: ৳3,601.62

₹5,911.93

List Price: ₹8,445.97

You save: ₹2,534.04

RM312.68

List Price: RM446.70

You save: RM134.02

₦118,358.68

List Price: ₦169,091.08

You save: ₦50,732.40

₨19,451.98

List Price: ₨27,789.74

You save: ₨8,337.75

฿2,421.30

List Price: ฿3,459.15

You save: ฿1,037.85

₺2,419.75

List Price: ₺3,456.94

You save: ₺1,037.18

B$406.81

List Price: B$581.19

You save: B$174.37

R1,266.21

List Price: R1,808.95

You save: R542.74

Лв131.43

List Price: Лв187.77

You save: Лв56.33

₩98,455.31

List Price: ₩140,656.47

You save: ₩42,201.16

₪260.61

List Price: ₪372.31

You save: ₪111.70

₱4,125.84

List Price: ₱5,894.31

You save: ₱1,768.47

¥10,813.84

List Price: ¥15,449

You save: ¥4,635.16

MX$1,432.62

List Price: MX$2,046.69

You save: MX$614.07

QR256.35

List Price: QR366.23

You save: QR109.88

P959.91

List Price: P1,371.36

You save: P411.45

KSh9,063.70

List Price: KSh12,948.70

You save: KSh3,885

E£3,476.67

List Price: E£4,966.88

You save: E£1,490.21

ብር8,762.26

List Price: ብር12,518.05

You save: ብር3,755.79

Kz63,877.12

List Price: Kz91,256.94

You save: Kz27,379.82

CLP$68,152.06

List Price: CLP$97,364.26

You save: CLP$29,212.20

CN¥507.37

List Price: CN¥724.85

You save: CN¥217.47

RD$4,236.71

List Price: RD$6,052.70

You save: RD$1,815.99

DA9,355.50

List Price: DA13,365.57

You save: DA4,010.07

FJ$159.32

List Price: FJ$227.62

You save: FJ$68.29

Q542.77

List Price: Q775.43

You save: Q232.65

GY$14,710.67

List Price: GY$21,016.15

You save: GY$6,305.47

ISK kr9,775.50

List Price: ISK kr13,965.60

You save: ISK kr4,190.10

DH703.21

List Price: DH1,004.63

You save: DH301.41

L1,276.61

List Price: L1,823.81

You save: L547.19

ден4,112.73

List Price: ден5,875.58

You save: ден1,762.85

MOP$563.70

List Price: MOP$805.33

You save: MOP$241.62

N$1,272.29

List Price: N$1,817.64

You save: N$545.34

C$2,573.53

List Price: C$3,676.63

You save: C$1,103.10

रु9,461.06

List Price: रु13,516.38

You save: रु4,055.32

S/267.08

List Price: S/381.56

You save: S/114.48

K283.05

List Price: K404.37

You save: K121.32

SAR262.80

List Price: SAR375.44

You save: SAR112.64

ZK1,938.90

List Price: ZK2,769.98

You save: ZK831.07

L334.76

List Price: L478.25

You save: L143.49

Kč1,707.89

List Price: Kč2,439.96

You save: Kč732.06

Ft27,663.65

List Price: Ft39,521.19

You save: Ft11,857.54

SEK kr779.03

List Price: SEK kr1,112.95

You save: SEK kr333.92

ARS$70,272.32

List Price: ARS$100,393.34

You save: ARS$30,121.01

Bs485.83

List Price: Bs694.07

You save: Bs208.24

COP$310,661.31

List Price: COP$443,820.90

You save: COP$133,159.58

₡35,743.76

List Price: ₡51,064.70

You save: ₡15,320.94

L1,776.85

List Price: L2,538.46

You save: L761.61

₲551,865.53

List Price: ₲788,413.13

You save: ₲236,547.59

$U2,996.30

List Price: $U4,280.61

You save: $U1,284.31

zł292.33

List Price: zł417.63

You save: zł125.30

Already have an account? Log In

Advanced Excel VBA Crash Course

Variable Decl 02

Sign Up

Sign Up

Share