Excel VBATutorial                      Tutorial on Excel macros

 

Excel VBA Macros

Excel Macros Table of Contents

Excel Visual Basic Editor

Excel Macros Vocabulary

Excel Userforms

Excel Consulting

Excel Tutorial on Macros

Email to excel-vba.com

Excel Macros Section 1: Programming Macros in Excel

In this first section you will learn how easy it is to record macros with the Macro Recorder and to create other macros of your own in the Visual Basic Editor.

You will discover that:

-  the Macro Recorder is not only a recorder but it is the best teacher and it will be a great assistant (writing code for you) even when you become an expert at programming in VBA.

- the Visual Basic Editor is the most user friendly development environment that tells you immediately if there are mistakes in your sentences so that you do not have to wait at the end of your project to realize that something that you have written is wrong.

- in the Visual Basic Editor you will create these powerful and useful userforms

- in the Visual Basic editor you will  test your macros step by step, modify them and improve them.

After section 1, you will be able to copy all the macros available on the intenet and use them efficiently in your own workbooks.

Lesson 1: Visual Basic Editor in Excel (VBE)

Lesson 2: Project  Window in the Visual Basic Editor

Lesson 3: Properties  Window in the Visual Basic Editor

Lesson 4: Code Window in the Visual Basic Editor

Lesson 5: Building Macros in Excel

Lesson 6: Testing Macros in Excel

Lesson 7: Macro Recorder in Excel

Lesson 8: Macros Help and Assistance

Lesson 9: Events in VBA for Excel

Lesson 10: Security and Protection in VBA for Excel


This website and the downloadable Tutorial on Excel Macros are divided in three sections:

Section 1: Excel Macros Programming: Lessons 1 to 10
This section is about recording, writing, modifying and testing macros in the Visual Basic Editor. You will also learn about security and discover "events" (an event is what starts the macro).

Section 2: Excel VBA Vocabulary: Lessons 11 to 23
Developing a macro is communicating with Excel and to do so you need to use a language called Visual Basic for Applications (VBA). In section 2 you will learn all the VBA vocabulary that is essential to work with business data (accounting, sales, production and others).

Section 3: Forms and Controls in VBA for Excel: Lessons 24 to 33
The userform is a small or large dialog window that you create and allows the user to submit values that will be used by your macros. To these userforms you will add controls (command buttons, text boxes, list boxes and others) and program them.

 

Excel Tutorial on Macros

Excel VBA Macros

Excel Macros Table of Contents

Excel Visual Basic Editor

Excel Macros Vocabulary

Excel Userforms

Excel Consulting