BEST TRAINING FOR VBA VIJAYANAGAR IN INDIA

Chapter 1: Visual Basic Editor (VBE) in Excel The Visual Basic Editor is the user friendly program that you will use to talk with Excel. In it you can create your VBA procedures (macros) and userforms. You will then be able to modify and test these components easily step by step in the VBE. Chapter 2: The Project Window in the Visual Basic Editor of Excel The Project Window lists all your open projects with their sheets, modules and forms. In the Project Window you will add modules and create forms. When you select one of the components its properties will show in the Properties Window and the VBA code that you have created for the selected component will appear in the Code Window. Chapter 3: The Properties Window in the Visual Basic Editor of Excel The Properties Window shows you the properties of the object that is selected in the Project Window (sheet, module) or the properties of the control (command button, text box, list box, etc...) that is selected on the forms. You will use this window often when you start developing forms (userforms). Chapter 4: The Code Window in the Visual Basic Editor of Excel All the action happens in the Code Window. In this large window you or the Macro Recorder will write macros. You will also test and fine tune all your macros in the Code Window. Chapter 5: Developing Macros in the VBE In this lesson you will learn how to create a new VBA procedure. You will organize sets of sentences to tell Excel what to do. You can key them in or copy/paste them from recorded macros, from one of your old macros or from the Internet where you will find millions of free macros. Chapter 6: Testing Macros in the VBE When you develop macros in Excel you spend 20% of your time analyzing the project, 15% writing your VBA procedures and 65% testing and fine tuning them. Split your screen, use the F8* key and you can see what your procedure does in Excel step by step. Back up, correct and re-test. Chapter 7: Excel Macro Recorder The Macro Recorder 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. In this lesson you will learn about the Macro Recorder and you will try it. You will also run and test the macro that you have recorded. Chapter 8: Macros Help and Assistance