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

Introduction

Advanced Excel VBA Crash Course USER FORMS

By: Yoda Learning

1 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

€58.77

List Price: €83.96

You save: €25.19

£50.96

List Price: £72.80

You save: £21.84

CA$94.80

List Price: CA$135.43

You save: CA$40.63

A$100.32

List Price: A$143.32

You save: A$43

S$88.81

List Price: S$126.88

You save: S$38.07

HK$546.47

List Price: HK$780.70

You save: HK$234.23

CHF 53.87

List Price: CHF 76.96

You save: CHF 23.09

NOK kr672.85

List Price: NOK kr961.25

You save: NOK kr288.40

DKK kr438.87

List Price: DKK kr626.98

You save: DKK kr188.11

NZ$115.94

List Price: NZ$165.64

You save: NZ$49.69

د.إ257.03

List Price: د.إ367.21

You save: د.إ110.17

৳8,573.27

List Price: ৳12,248.05

You save: ৳3,674.78

₹6,439

List Price: ₹9,198.97

You save: ₹2,759.96

RM275.90

List Price: RM394.16

You save: RM118.26

₦97,280.50

List Price: ₦138,978.10

You save: ₦41,697.60

₨19,584.95

List Price: ₨27,979.70

You save: ₨8,394.75

฿2,202.95

List Price: ฿3,147.21

You save: ฿944.25

₺3,044.65

List Price: ₺4,349.69

You save: ₺1,305.03

B$363.62

List Price: B$519.48

You save: B$155.86

R1,120.79

List Price: R1,601.20

You save: R480.40

Лв114.95

List Price: Лв164.23

You save: Лв49.27

₩101,142.45

List Price: ₩144,495.41

You save: ₩43,352.95

₪217.06

List Price: ₪310.11

You save: ₪93.04

₱4,128.68

List Price: ₱5,898.37

You save: ₱1,769.68

¥10,797.84

List Price: ¥15,426.15

You save: ¥4,628.31

MX$1,213.80

List Price: MX$1,734.07

You save: MX$520.27

QR254.84

List Price: QR364.07

You save: QR109.23

P914.99

List Price: P1,307.19

You save: P392.19

KSh9,047.60

List Price: KSh12,925.70

You save: KSh3,878.10

E£3,284.79

List Price: E£4,692.76

You save: E£1,407.96

ብር10,858.94

List Price: ብር15,513.44

You save: ብር4,654.50

Kz63,840.18

List Price: Kz91,204.17

You save: Kz27,363.99

CLP$60,121.41

List Price: CLP$85,891.41

You save: CLP$25,770

CN¥486.62

List Price: CN¥695.21

You save: CN¥208.58

RD$4,408.55

List Price: RD$6,298.19

You save: RD$1,889.64

DA9,056.28

List Price: DA12,938.09

You save: DA3,881.81

FJ$153.89

List Price: FJ$219.85

You save: FJ$65.96

Q538.34

List Price: Q769.09

You save: Q230.75

GY$14,678.69

List Price: GY$20,970.46

You save: GY$6,291.76

ISK kr8,521.28

List Price: ISK kr12,173.78

You save: ISK kr3,652.50

DH635.36

List Price: DH907.70

You save: DH272.33

L1,177.29

List Price: L1,681.92

You save: L504.62

ден3,614.89

List Price: ден5,164.35

You save: ден1,549.46

MOP$564.05

List Price: MOP$805.82

You save: MOP$241.77

N$1,111.79

List Price: N$1,588.34

You save: N$476.55

C$2,582.52

List Price: C$3,689.47

You save: C$1,106.95

रु10,329.73

List Price: रु14,757.39

You save: रु4,427.65

S/234.11

List Price: S/334.46

You save: S/100.35

K298.19

List Price: K426

You save: K127.81

SAR262.50

List Price: SAR375.02

You save: SAR112.51

ZK1,387.48

List Price: ZK1,982.20

You save: ZK594.72

L299.61

List Price: L428.03

You save: L128.42

Kč1,430.14

List Price: Kč2,043.15

You save: Kč613

Ft22,445.51

List Price: Ft32,066.39

You save: Ft9,620.88

SEK kr620.16

List Price: SEK kr885.98

You save: SEK kr265.82

ARS$101,071.33

List Price: ARS$144,393.80

You save: ARS$43,322.47

Bs484.78

List Price: Bs692.58

You save: Bs207.79

COP$257,761.83

List Price: COP$368,246.97

You save: COP$110,485.14

₡34,717.51

List Price: ₡49,598.57

You save: ₡14,881.06

L1,853.33

List Price: L2,647.73

You save: L794.40

₲470,834.47

List Price: ₲672,649.51

You save: ₲201,815.03

$U2,715.88

List Price: $U3,879.99

You save: $U1,164.11

zł247.64

List Price: zł353.78

You save: zł106.14

Already have an account? Log In

Advanced Excel VBA Crash Course

Introduction

Sign Up

Sign Up

Share