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: Modifying Macros in Excel
Lesson 9: Events in VBA for Excel
Lesson 10: Security and Protection in VBA for Excel