3 Excel VBA Tutorials

Here are 3 Excel VBA tutorials from Computerprogramming.suite101.com that teach you how to code VBA in Excel for the following functionality: Looping in a Cell Range, Changing Cell Color, and Conditional Summing.


How to Loop in Cell Range in Excel

This is an Excel VBA programming tutorial that shows you 3 methods on how to loop through ranges of cells. It demonatrates and reviews loops that are counted, uncounted and user defined. Coding loops in Excel in this manner allow functionality to be applied through an array of objects in several ways. A counted loop iterates a given number of times; an uncounted loop iterates until a specified condition is fulfilled.

The following are tasks that can be accomplished while looping through Excel cell ranges:

• Changing cell color based on a condition;
• Creating sets of data;
• Generating reports.

Changing the Cell Color with VBA

This Excel tutorial demonstrates a useful VBA coding technique for modifying cell properties in a range based on what the contents are for each cell.


Conditional Sum Examples in Excel

Conditional Summing is an Excel feature that you can use to calculate the sum of a set of cells based on looking at the values in each of the cells. An example would be summing only those values in a range of cells that are above the mean (average) of all the values in the range.

There are three conditional sum functions, as follows:

• SUMIF
• COUNTIF
• IF