So you need to learn Microsoft VBA / Macro Programming? There are many ways to go about learning macro programming. One of the easiest is to work one-on-one, face-to-face with a Microsoft Excel MVP slash Excel VBA/Macro Trainer. It is actually the BEST way to learn Microsoft Excel. So why do we suggest starting with the Macro Recorder?
♦ The easiest way to learn to program Microsoft Excel VBA (Macro Programming) is to start by first learning to record, and then edit your macros. The Macro Recorder will allow you to record and to run simple macros. It will write the code for you. But the code is not optimal, and that is where the learning comes in; you learn to take poorly written code, and you write it correctly. An amazing way to learn. And because it is a great way to get started. VBA programming is an effort and you need to start somewhere. Remember, VBA taught thru baby steps. You must start somewhere and this is the best place to start, learning Microsoft Excel VBA/Macro Programming, one-on-one, face-to-face with an Excel MVP. What are you waiting for?
♦ The recorded macro will work, even if the code is not optimally written. As such, you can learn to re-write the poorly recorded code, line by line. As you do that, you will be learning how to program in Microsoft Excel VBA. One line of code at a time, as time allows. Remember, the recorded macro will work, so you can take your time to learn it and to revise it. When you finish the code it will perform much better than the recorded code.
♦ But wait, why would you want to record an Excel Macro versus just type it? Well, because you have not yet learned how to program Excel Macros, and this is a great way to start. How can you type in the code if you do not know the code? Hence, the Macro Recorder will show you the code to use to do what you would like to have done.
♦ Think of using the Macro Recorder as you would think about using the Excel Charts Wizard. In Excel you can create a chart manually or you can use the Excel Charts and Graphs Wizard, to “create” your charts and graphs. Of course they will not be 100% as you would like them to be, but the Wizard will quickly create attractive charts for you. So we recommend that you use the wizard to quickly build the chart, and then edit the parts of the chart that you want to change. Easier and quicker than starting from scratch. Use the Wizard, use the Recorder.
♦ Same approach to writing your first macros, use the Macro Recorder and begin the journey of becoming as good in Excel VBA as a Microsoft Excel Subject Matter Expert, an Excel MVP.
Your Situation and Your Needs. Say for example that you need to learn Excel VBA for your work:
So you use Microsoft Excel as part of your daily duties at work, say for example, you are the Senior Director of Finance and that you report directly to the Senior VP of Finance. For this example, let’s say that your employer asked you to learn Microsoft Excel VBA so that you can take on new, high -level responsibilities at work. Which may lead to a promotion.
♦ You have been asked to focus on automating and/or integrating portions of your time demanding work flow in the finance department. Basically you need to master Microsoft Excel VBA and currently you have no idea of how any of this works. So where do you get started? Simple, Microsoft created the Macro Recorder for situations just like this. You can record some of your simpler automation efforts in Excel by using the Excel Macro Recorder.
♦ You can see how the code might look, but knowing that it is not ideal. So you start with the Macro Recorder, and then you edit the VBA that was recorded for you. You can open then that code, and re-write it to work optimally, learning Excel VBA along the way.
10-Minutes on Recording and Editing an Excel Macro, working one-on-one with a legendary Microsoft Excel MVP, out of New York:
♦ We pulled ten minutes of a recorded one-on-one Excel training session, covering how and why to first record, then edit a macro, in order to learn VBA. The recording is raw and unedited, it is just an example of what face-to-face Excel training can go.
♦ If you are going to hire 1 trainer to help you, why not hire the BEST Trainer for the money? Why pay more, for less? You are hiring the Excel trainer to train you, so make sure that trainer is a Microsoft Certified Excel Subject Matter Expert.
300-101 400-101 300-320 300-070 300-206 200-310 300-135 300-208 810-403 400-050 640-916 642-997 300-209 400-201 200-355 352-001 642-999 350-080 MB2-712 400-051 C2150-606 1Z0-434 1Z0-146 C2090-919 C9560-655 642-64 100-101 CQE CSSLP 200-125 210-060 210-065 210-260 220-801 220-802 220-901 220-902 2V0-620 2V0-621 2V0-621D 300-075 300-115 AWS-SYSOPS 640-692 640-911 1Z0-144 1z0-434 1Z0-803 1Z0-804 000-089 000-105 70-246 70-270 70-346 70-347 70-410