Discover Excel Macros

Get Started for FREE

If you have any difficulties with these exercises write to:
peter@excel-vba.com

Note: You can come back to this page using the "Beginners" button at the bottom of each page of this website.

Discovering macros and programming in Excel is quite easy if you follow the right steps and learn the right things. The exercises below are a great start and they are FREE.

Before you invest too much time and money into discovering the power of Excel macros, let us guide you through the basic steps to help you make the right decisions.

Excel macros are powerful tools and they will allow you to do much more with Excel and to do it more rapidly.

You can easily learn to develop your own macros or use one of a few thousands macros already developed by others and that are available on the World Wide Web. Most of them are free.

Follow these first 3 steps:

Step 1: If you are using Excel 2007 you need to install the Visual Basic Editor for Excel from your Office CD. If you are using any older version of Excel (1997-2006) you do not need to install anything to work with macros in Excel. Everything is there, you just need to discover how to get to it

Step 2: Make sure that the level of security of your copy of Excel allows you to use macros.

For users of Excel 1997 to 2006: 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 2007 to 2010: From the "Developer" ribbon click on the "Macro Security" button. Check the second level "Disable all Macros with Notification" and you are set.

Step 3: When you want somebody to do some work for you, you open your Email program and you send him/her a message in a language that he/she 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). We will first guide you through the set up process of the Visual Basic Editor for Excel.

Now you are ready to develop macros and userforms.

Create your first macro and run it. Complete the 3 small and simple exercises in:

- lesson 2 (Project Window)
- lesson 3 (Properties Window)
- lesson 4 (Code Window).

Record your first macro and run it. Complete the exercise in lesson 7 (Macro Recorder in Excel) 

Create you first userform and use it. Complete the following 7 exercises: - Userforms in VBA for Excel

Congratulations you are no longer a beginner!

You are now ready to learn much more

Download the
Tutorial on Excel Macros