Example VBA Project

By project is meant a VBA program interacting with an Excel spreadsheet. This first example is not one that would actually require a VBA program since it is too simple. However, it shows the basics of 

This program takes numeric data from an Excel spreadsheet and calculates the average of the numbers. The input data look similar to the following  

The user must supply a list of numbers to be averaged in a vertical column ending with a blank cell. It calculates the average of the numbers and outputs the average on the spreadsheet row after the blank cell. For the sample data shown, the final appearance of the spreadsheet is as follows  

Note Before the program is executed, the cursor (selected cell) must be the one with the text Numbers to be Averaged before running the program. 

While designing the algorithm, several variable names have been chosen (invented). These names are chosen by the programmer and should, in some way, be descriptive of the data that they represent. A description of the chosen variable names is as follows  

---