Microsoft Excel Macros
 

Excel Macros Section 1: Programming Macros in Excel
By Pierre Leclerc.


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: Modifying Macros in Excel

Lesson 9: Events in VBA for Excel

Lesson 10: Security and Protection in VBA for Excel


left arrow Back home