Section 1: Get Started with Excel VBA

1.1 Developer

1.2 VBA Editor

1.3 Macros

1.4 Dot Notation

1.5 Toolbar

1.6 Buttons

1.7 Offset

1.8 Resize

Section 2: Excel VBA Variables

2.1 Variables

2.2 Variable Practice

2.3 Option Explicit

2.4 Add/Subtract

2.5 Multiply/Divide

2.6 More Types

Section 3: Excel VBA if

3.1 If Statements

3.2 Else ... Else If

3.3 Conditions

3.4 Logic Operators

3.5 VBA Practice 1

3.6 VBA Practice 2

3.7 Select Case

3.8 VBA Practice 3

3.9 With ... End With

Section 4: Text and Excel VBA

4.1 VBA Strings

4.2 Change Case

4.3 Trim, Len, Space

4.4 Replace

4.5 In the String?

4.6 Left and Right

4.7 VBA Mid

4.8 String Exercise

Section 5: Excel VBA and Loops

5.1 VBA For Loops

5.2 VBA For Each

5.3 Cells Property

5.4 Do Loops

Section 6: Excel VBA Arrays

6.1 An Introduction to Arrays

6.2 Arrays, Loops

6.3 Multi Arrays

6.4 Arrays and Split

Section 7: Subroutines and Functions

7.1 Subroutines

7.2 Pass Value to Sub

7.3 The Message Box

7.4 Functions

7.5 Worksheet Function

7.6 The Set Keyword

Section 8: Excel VBA and Text File

8.1 Open Text File

8.2 Write to file

Section 9: Excel User Forms

9.1 User Forms

9.2 Form Buttons

9.3 Launch a Form

9.4 Add Tab to Ribbon

9.5 Customize Excel Ribbon

Section 10: Walkthrough: Picture Viewer

10.1 Excel Picture Viewer

10.2 Design a Form

10.3 Add Buttons

10.4 Add New Tab

10.5 Form Initialize

10.6 Textbox Data

10.7 VBA Option Button

10.8 VBA ImageBox Code

10.9 Next/Previous Buttons

10.10 Add New Photo

10.11 Save New Image

10.12 Copy Image

Section 11: Walkthrough: Excel Charts

11.1 Chart Sheets

11.2 Embedded Charts

11.3 Charts Forms, P1

11.4 Charts Forms, P2

11.5 Chart Constants

Section 12: Walkthrough: VBA TreeView

12.1 TreeViews

12.2 Parent/Child Nodes

12.3 Initialize Nodes

12.4 Node Click Event

Home and Learn - Free Excel VBA Course

---

Excel VBA Chart Constants

Excel VBA has quite a lot of constants you can use for chart types. In a previous section, we used xlColumnClustered. We used it like this:

.ChartType = xlColumnClustered

In the links below, you'll find all the VBA constant you can use in place of xlColumnClustered. You'll also see images of what each chart type looks like.

Each link opens in a new browser tab.

Column Charts

Bar Charts

Line Charts

Pie Charts

Scatter Charts

Area and Other Charts Types