In the first exercise, we will focus on variables and some calculations. This is a nice follow up to the Hello worldtutorial in Beginner tutorials on VBA.
Body mass index (BMI) is a value derived from the mass (weight) and height of a person. It is a convenient rule of thumb used to broadly categorize a person as underweight, normal weight, overweight, or obese.
The BMI is defined as
Your task is to create a sheet where you can calculate your BMI by entering your name, height and weight. The calculated BMI should be displayed by the click of a button. A draft to a finished solution is shown below.
Commonly accepted BMI ranges are:
BMI [kg/m2]
Underweight
< 18.5
Normal weight
18.5 - 25
Overweight
25 - 30
Obese
> 30
There are as always a number of ways to solve this task, so don't be alarmed if your answer differentiates from our solution.
Make sure you have enabled the Visual Basic shortcut in Excel, as this is used in the video. If you have not,click this link.