You input appears in black, comments appear in green, reserved words in blue and when you make a mistake the font color turns to red. NOTE: You cannot change the font or its color in the code window.
In lesson 9 on Events you will discover many other ways to start a macro. You have run the macro from the menu bar of Excel.
On the menu bar go to "Tool" and click on "Macros". In the dialog window select "proFirst" and click on run. Step 7: Go to Excel and clear the cells A1, A2 and A3 of "Sheet1". The value of cell "A1" is 34, the value of cell "A2" is 66 and there is a formula in cell A3 that sums cells A1 and A2. Go to Excel and "Sheet1" and see that what the macro was ordering Excel to do has been done. Step 6: Go to Excel (ALT/F11) and see what has happened to cells A1, A2 and A3Ĭongratulations you have run and tested you first macro. Step 5: Click on any line of the macro, go to the menu bar at the top of the VBE screen and click "Run" then click "Run Sub/Userform". Make sure that everything is there including all the quotation marks, periods, parentheses, equal signs and spaces. Enter the rest of the code within the two lines. If you decide to key it in you will start by entering the first line and then when you press enter the VBE will add the final Line "End Sub". Step 4: You can either copy/paste the following macro from your browser to the code window of "Sheet1" or key it in. Step 3: Click anywhere in the Code window You will later develop the habit of creating modules and organizing your macros within them. On the right is the Code window of "Sheet1"įor the purpose of this exercise we will develop a small macro within the code window of a sheet. Step 2: Double click on "Sheet1" in the Project Window. Step 1: In Excel notice that cells A1, A2 and A3 of "Sheet1" are empty.
To illustrate everything that you can do in the Code window we will start by creating a small macro in an empty workbook.Įxercise 6 (Create your first macro and use it) The Code Window is where 90% of the VBA work is done writing VBA sentences, testing your VBA procedures (macros) and modifying them when needed. Use ALT/F11 to navigate from the Visual Basic Editor to Excel as you learned in lesson 1. Note: Print this page, open Excel and a open a new workbook. Lesson 4 on Excel macros (VBA): The Code Window in the VBE of Excel Here is a sample of what you will find in lesson 4 of the downloadable Tutorial on Excel macros
0 kommentar(er)
