VBA Excel

VBA Excel Tutorial

Hello Friends,

When you want somebody to do some work for you, you ask/request/command in a language that he understands (English, Hindi, Tamil...). When you want EXCEL to do some work for you, you open the Visual Basic Editor and you write the instructions in a language that Excel understands VBA (Visual Basic for Application).

Section - I
Excel Macros Programming:

Lesson 1: Setting up VBE (Visual Basic Editor)
Lesson 2: Project Window in VBE
Lesson 3: The Properties Window in the Visual Basic Editor of Excel
Lesson 4: The Code Window in the Visual Basic Editor of Excel
Lesson 5: Developing Macros in Excel
Lesson 6: Testing Macros in the Visual Basic Editor for Excel
Lesson 7: The Macro Recorder in Excel 2007 to 2010
Lesson 8: Macros Help and Assistance
Lesson 9: Starting, Triggering a Macro in Excel 2007 to 2011 (The Events)
Lesson 10: VBA Macros Security and Protection in Excel (Excel 2007 and 2010)

Section - II
Excel VBA Macros Vocabulary:

Lesson 11: VBA Coding Tips
Lesson 12: VBA for Excel to Manage Errors
Lesson 13: VBA for Excel for the Application
Lesson 14: VBA for Excel for Workbooks
Lesson 15: VBA for Excel for Worksheets
Lesson 16: Cells, Ranges, Columns and Rows in VBA for Excel
Lesson 17: Message and Input Boxes (MsgBox, InputBox) in Excel
Lesson 18: Excel VBA Vocabulary to Filter and Sort Data
Lesson 19: VBA for Excel Variables
Lesson 20: VBA for Excel Statements
Lesson 21: Functions in VBA for Excel
Lesson 22: External Data and SQL in VBA for Excel
Lesson 23: Working with Other Microsoft Programs in VBA for Excel

Section - III
Excel VBA Forms & Controls:

Lesson 24: Forms (Userforms) in VBA for Excel
Lesson 25: Userforms Properties and VBA Code
Lesson 26: Labels in VBA for Excel
Lesson 27: Text Boxes in VBA for Excel
Lesson 28: Command Buttons in VBA for Excel
Lesson 29: Combo Boxes in VBA for Excel
Lesson 30: List Boxes in VBA for Excel
Lesson 31: Option Buttons, Check Boxes and Frames
Lesson 32: Excel Spin Buttons
Lesson 33: Excel Image Controls

Excel VBA 2010 - Simplified

If you think that creating macros is too complicated or beyond your capacity, don't worry, this course is intended for those of us who are just starting out in programming, so it starts from zero.

These lessons have lots of examples, and we've simplified them as much as possible so that it's easy to learn VBA. We recommend that you work your way through the lessons in the order in which they are provided, because at each level you will need the skills acquired in the previous ones.