Excel VBA Programming

 

Chapter

Video

Material

1

Overview

1.01 Enable Developer Tab

1.02 Macro Security

1.03 Record my first Macro

1.04 Create cross Worksheet Macro

 

Overview

Lecture Note

Exercise

Source File

2

2.01 Introduction to VB Editor

2.02 Declare Variables

2.03 Using MsgBox function

2.04 Using InputBox function

2.05 Using Control

 

 

3

3.01 Hide all Inactive Worksheet

3.02 Unhide all Worksheets

3.03 Protect Worksheet with Password

3.04 Unprotect Worksheet

3.05 Sort Worksheet

3.06 Save Worksheet to PDF

3.07 Convert Range into Image

3.08 Unhide all Rows and Columns

3.09 Spell Check

3.10 Text to Speech

Exercise

 

SFQ – HKCC

SFQ – SPEED