We used the macro recorder in class to create a macro. The steps involved were: “toy” Select the Developer tab in the Ribbon, then focus on the Code section of • the tab, on the left. Click on Record Macro. The Record Macro dialogue box will appear. Enter the name of the macro, typed as one word, and the description of the • macro in the dialogue box. Pay attention to the option "Store macros in:" window of the dialogue box. Make sure that for this class you use the option "This Workbook". This will ensure that your macro is recorded into the workbook you are working in. There are some other options which we will be discussing later in the course. "OK". The Record Macro dialogue box will close. At the very • bottom left of the Excel display you’ll see a little rectangular Stop button. The recorder is now recording every action that you take with the computer. Undertake whichever actions you wish to have recorded. Remember that • the recorder will quite literally copy every action you take until you shut the recorder off. Thus, if you make a mistake and correct it, every time you LATER run the macro Excel will make the same mistake and then correct it (if Thus I recommend that before using the macro possible). recorder you practice your action or actions several times to make sure you are doing them correctly so that your recorded macro is If “clean.” the macro to be recorded is long and complex, make some shorthand notes on a sheet of paper to remind you of the steps to be taken and the order in which to take them. Finally, when you are finished click on the Stop button to stop recording • the macro. Once the macro is recorded, you run or play the macro by using the Macros button in the section of the tab. A dialogue box will pop up which lists any macros which Code Developer you have available to you. To run a macro you have created, click on the macro in question and then click the Run button.
We used the macro recorder in class to create a “toy” macro. The steps involved were: • Select the Developer tab in the Ribbon, then focus on the Code section of the tab, on the left. Click on Record Macro. The Record Macro dialogue box will appear. • Enter the name of the macro, typed as one word, and the description of the macro in the dialogue box. Pay attention to the option "Store macros in:" window of the dialogue box. Make sure that for this class you use the option "This Workbook". This will ensure that your macro is recorded into the workbook you are working in. There are some other options which we will be discussing later in the course. • "OK". The Record Macro dialogue box will close. At the very bottom left of the Excel display you’ll see a little rectangular Stop button. The recorder is now recording every action that you take with the computer. • Undertake whichever actions you wish to have recorded. Remember that the recorder will quite literally copy every action you take until you shut the recorder off. Thus, if you make a mistake and correct it, every time you LATER run the macro Excel will make the same mistake and then correct it (if possible). Thus I recommend that before using the macro recorder you practice your action or actions several times to make sure you are doing them correctly so that your recorded macro is “clean.” If the macro to be recorded is long and complex, make some shorthand notes on a sheet of paper to remind you of the steps to be taken and the order in which to take them. • Finally, when you are finished click on the Stop button to stop recording the macro. Once the macro is recorded, you run or play the macro by using the Macros button in the Code section of the Developer tab. A dialogue box will pop up which lists any macros which you have available to you. To run a macro you have created, click on the macro in question and then click the Run button.
Visual%20Basic%20Introduction.docx