Australian Rules is a type of football. You score points by getting the ball between posts at either end of the field:
If the ball goes between the center two posts, that's a goal, and is worth six points. If the ball goes between one of the center and outside posts, that's a behind, and is worth one point.
Make a worksheet that starts like this:
The user enters values for goals and behinds, clicks the button, and your VBA program outputs the total score. Here's an example:
Here's another example:
Upload your workbook.