ExcelVbaUserformExamplesFreeDownloadSection 1 Programming in Excel MacrosHere are samples of what you will find in Section 1of the downloadable Tutorial on Excel macros. Print this page to read it at home, at the office, on the bus or the train. Excel Macros Section 1 Programming Macros in Excel. 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. What is the Excel VBA Handbook The Excel VBA Handbook is the only available course that teaches you how to build VBA applications from scratch. 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. 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. 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 internet and use them efficiently in your own workbooks. Here is a sample of what you will find in chapter 1of the downloadable Tutorial on Excel macros. The Visual Basic Editor in Excel VBEWhen you want somebody to do some work for you, you open your Email program and you send him a message in a language that he understands English, Spanish, French. When you want Excel to do some work for you, you open the Visual Basic Editor and you write the instructions in a language that Excel understands VBA Visual Basic for Application. You will develop, test and modify VBA procedures macros in the Excel Visual Basic Editor VBE. It is a very user friendly development environment. VBA procedures developed in the VBE become part of the workbook in which they are developed and when the workbook is saved the VBA components including macros, modules, userforms and other components that you will discover in the next 3. So, when you send the workbook to the Recycling Bin the VBA procedures macros are destroyed. Notes. Special note for users of Excel 2. Until the 2. 00. 7 versions of Excel the user did not need to install anything to work with macros in Excel. If you are using Excel 2. Visual Basic Editor for Excel from your Office CD. GTWYqwQO8/hqdefault.jpg' alt='Excel Vba Userform Examples Free Download' title='Excel Vba Userform Examples Free Download' />Ree Excel Downloads. Excel Functions and VBA Visual Basic for Applications. Office Tips. Tips and tutorials for Microsoft Excel Access, Word, FrontPage and VBA from trainer and consultant Martin Green. Sample Excel Files. Free Excel workbooks that you can download, to see how functions, macros, and other features work. Some files contain VBA code, so enable macros. Interested in learning more about Excel VBA MrExcel will teach you how to use Microsoft Excel VBA. Check out our site for more information about Excel VBA tutorials. IMPORTANT NOTE 1 There are no risks to your computer or to Excel in completing the task below. At any time if you feel uncomfortable, just close Excel without saving the workbook and try again later. For users of Excel 1. The first thing that you need to do is to make sure that the security level of Excel is set at either Low or Medium so that you can use the macros VBA procedures that you develop. From the menu bar of Excel select Tools then Macro then Security and select Medium. For users of Excel 2. From the Developer ribbon click on the Macro Security button. Check the second level Disable all Macros with Notification and you are set. Setting up  the Visual Basic Editor in Excel VBEThe Visual Basic Editor is a program within Excel that allows you to communicate with Excel. We will open it and start by setting it up so that working within it becomes easy and efficient. Print this page, open Excel and open a new workbook Book. On your keyboard press the ALT key left of the space bar and hold, strike the F1. F1. 1 key is at the top of your keyboard. You now see the Visual Basic Editor. Again press ALTF1. Excel. Use the ALTF1. Excel to the VBA and back. When you first open the VBE you will see is a window somewhat like the image below. If there are any open windows within the VBE like in the image below click on the Xs to close them and see a gray rectangle filling up the bottom part of the screen like in the image above. The Three Windows in the Visual Basic Editor. To be efficient when working with the VBE there should always be 3 windows showing like in the image below  the Project Window 1,  the Code Window 2, and the Properties Window 3, arranged as in the image below. You can resize the windows by left clicking where the red stars are, holding and moving sideways or up and down. We will study each of the three windows in lessons 2, 3 and 4 but first we will set them. VBE. In the exercise below we will setup the 3 windows of the VBE. Exercise 1 Create your first macro and use itRemember that you will perform this task only once as each time you will open the VBE it will remain setup. Step 1 Close all the windows that are open in the VBE to end up with this Step 2 Go to the menu bar View and click Project Explorer. The result will be somewhat like the image below If the project window already appears as a column on the left side of the screen there is nothing else that you have to do for now. If the project window appears in the middle of the gray area like above, right click in the white space in the middle of the project window and check Dockable. Then click on the top blue bar of the Project window, hold and drag it left until the cursor white arrow touches the middle of the left side of the screen. When you let go of the mouse button the end result should be like shown in the image below. Congratulations you have setup the first major window of the VBE. Step 3 Move your cursor on the line separating the project window and the gray rectangle. When it turns to two small parallel lines and arrows click, hold and move the lines sideways. Resize the two windows as you want them. Step 4 Go back to the menu bar View and click Properties Window. The Properties window will appear somewhat like in the image below. If the Properties window is already located below the Project window there is nothing left to do. If it shows like in the image above, right click in the white space in the middle of the Properties window and check Dockable. Then click on the top blue bar of the Properties window and drag it left and down until the cursor white arrow touches the center of the bottom of the Project window. When you let go of the mouse button the end. Congratulations you have setup the second major window of the VBE. Step 5 Move your cursor on the line separating the project window and the properties window. When it turns to two small parallel lines and arrows click, hold and move the lines vertically. Resize the two windows as you want them. Step 6 To add the code window to the setup, you just have to double click on the name of a component in the Project window Sheet. Sheet. 2, Sheet. 3 or This. Workbook and its code window appears within the gray rectangle. You can maximize any Code window by clicking on its Maximize button  . The final result looks like the image below. The words Option Explicit might not be present in your Code window. We will address this issue later in the lesson on variables Lesson 1. You might also have a VBAProject named FUNCRES. XLA or FUNCRES. XLAM in the project window. Forget about this project for now. Step 6 Now go to Excel and close it. Re open Excel, go to the VBE ALTF1. VBE setup persists. Congratulations, you are now ready to work in the Visual Basic Editor. We will discover more about each of these three windows in chapter s 2 Project Window, 3 Properties Window and 4 Code Windows. Remember that you can use ALTF1. Excel to the VBE and back. Close the VBE and close Excel without saving anything. The Excel VBA Handbook. Most people try to learn VBA the wrong way Maybe you have bought a book on VBA and tried to learn by working through it. Maybe you have taken a three day VBA course and tried to learn this way. Maybe you used Google and tried to learn from the different websites. Despite all this, the thought of building your first VBA application still seems overwhelming. You may have even built your first application but found it a slow and painful experience. World Of Warcraft Joomla Templates. Most people build their first VBA application by using Google to create every single line of code. The reason why people struggle to learn VBA is simpleNo course or book teaches you how to create. VBA application They explain all the parts of the VBA language but they leave it up to you to figure out how to put it all together. Imagine trying to learn to drive a car from listening to someone talking for 8 hours. Imagine trying to learn how to ride a horse from reading a book. It would be ridiculous. Learning VBA is no different. The only way to learn how to build VBA applications. VBA applications Its not only about building an application. You need to know how to build it the right way. Most people write awful code in their first application. Over time they eventually learn how to create proper applications. But this comes after much trial, error and frustration. Imagine Skipping all this frustration and time wasting Learn VBA from someone who does it professionally Becoming a skilled VBA coder in a fraction of the time it takes most people Having access to the programming secrets and little known techniques used by the top VBA coders. When I first thought about a course like this, it seemed to me like a no brainer. Yet, no course like this existed. I considered creating the course myself. At first I was reluctant. It would take considerable time and effort to create full applications and to provide a step by step guide for each one. Based on the number of comments and queries from readers of my blog it was apparent that most people struggle to create VBA applications. Time and time again I was seeing mistakes and frustrations that could easily be avoided if the user has access to the right information. I floated the idea to people on my email list. A course that shows you how to build 1. VBA applications from start to finish. The applications would cover a wide variety of VBA applications so the user could see how the same principles can be applied to any application. The feedback was overwhelmingly positive. People were literally begging me to create it. Twelve people paid up front from me to go ahead and create the package. And this was how the Excel VBA Handbook came to exist.