Your simple program
Write a program like the tip calculator, length converter, and Aussie Rules scorer. When a button is pressed, it should take some input from the worksheet, do some calculation(s), and output to the worksheet, using the IPO pattern. Input and output can be numeric and/or string.
Add a comment for each part of your IPO code, like "Arr! Here be input, maties!" You don't have to do Pirate, though.
Use good variable names,
Option Explicit, and other things you need.
Upload your worksheet.
Write a program that asks the user about their name, their dog's name, and shows a message. All input and output is with dialogs. First, the program asks for the user's first name:
Then the last name:
Then the dog's name:
That's all the input. After that, your program shows a message, that puts together the data:
Format the message exactly, with the right spacing, and the line breaks.
Notice something else you need to do. The user might type extra spaces around their input, like they did with the dog name.
Make sure the extra spaces do not affect the output.
Another run sequence:
Upload your worksheet. The usual coding standards apply. Good variable names, like that.
Write a program to help users work out how much fabric they need to make a covering for their fave cylinder. The input should be from the worksheet, like this:
I asked Google how to work out the surface area of a cylinder. It said:
Here's the output for that data:
Problem, though. The input is in centimeters. The output should be in square meters. I asked Google about that, too.
Another example. The input:
Upload your workbook. The usual standards apply.
Write a program that computes how many experience points (XP) a player earns in a game. They earn XP from killing things like rats, and zombies. You can download this starting workbook.
Here's the start screen:
The user enters numbers in the cells, and clicks the button. Here's some sample output:
Here's what each critter is worth:
Upload your solution. The usual coding standards apply.