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 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
Section 2: Excel VBA Vocabulary: Lessons 11 to 23
Section 3: Forms and Controls in VBA for Excel: Lessons 24 to 33