Microsoft excel visual basic made easy

Also, how to change automatically the color of a cell depending on the value. Pivot Table are so useful when it comes to aggregate data and sort it.

Solver: an convenient way to find the solution to complex problems like shortest path, etc Financial Formulas: we will look into the most used financial equation given by Excel. Here a glimpse of what it provides you. Date, Time: how to get todays dates or change the date format, etc Text handling: these functions allow to work with text like adding letter, putting words together, finding words, etc In this section we will do a few exercises or projects together.

Bank Loan: you want to know how much you will have to pay for this loan. Let's do it together. Bank Interest: you want to know how rich you will be in 5 months or 50 years from now. Curves: Graph functions in Excel. Graph a Linear Function In Excel. Plot a Function among the ones given in the example. Draw some nice curves and functions. A picture is worth words. Same for curves and graphs. Here a great spreadsheet. Love Phrase generator: You are unsure about what to say to your loved one.

Let's do a love phrase generator together. Budget: Lets make a simple budget together. Kitty Budget: Lets add some Kitty background or any other background movies, sport, nature, etc To do List: how useful is it to have this reminder. More Examples: Here you will find many examples of files, templates and also links to other sites with example.

In this page we will give you some important links because the web is full of great resources. In the basic Pages you will discover some important concepts and tools to start with Excel. In the advanced Pages : we will go through the fundamentals of VBA. Always following the principle, learning VBA must be fun and useful.

Personalize the Ribbon : very useful to put some frequently used buttons in the top ribbon. Multiple spreadsheets: how to move from one spreadsheet to another. Correct your mistakes: it is very important to correct your spelling errors as well as the grammatical errors.

Find Text : easily find a word, a phrase that you wrote in your spreadsheet but cannot remember where it was. This line tells VBA to process all the cells in your selection one-by-one. In order to do anything with the cell being processed for each time the loop runs its course, we tell VBA to assign each cell to the variable r.

Simple, right? The way Excel does this is by using a counter to keep track of where it is within the range. So, before we deleted the row, VBA was at row So only the items inside the If statement will be executed if the If statement evaluates to True. This tells Excel to move to the next row down, which is row 3. Think you know where the bug is? Delete to r. But that only makes the cells blank, and you want to remove the entire row for all of those.

There is a lot of power in Excel VBA. When I started learning about it, I wanted to automate everything - and I practically did. I became so good at my job because I was getting things done faster than everyone else. This got me noticed, which was good. Then I started sharing the tools I created with my teammates and then we became faster as a team. This got me a raise, which was better. If you continue on learning how to harness the power of VBA, it will help you out tremendously.

So what are you waiting for? In this chapter, learn how to create a simple macro. A loop in Excel VBA enables you to loop through a range of cells with just a few codes lines.

In Excel VBA, you can refer to a specific variable element of an array by using the array name and the index number. We call it the Application object.

The application object gives access to a lot of Excel related options. Become a VBA pro! You can find related examples and features on the right side of each chapter at the bottom of each chapter. Below you can find an overview scroll down for more information. You will often need this structure in more complicated programs as we will see later. This example teaches you how to run code from a module. All you have to do is record a specific task once. Next, you can execute the task over and over with the click of a button.