Situation:
Your program needs input from the user. You know exactly how many elements you need, and what type each one is. The tip program is an example.
Actions:
Choose a few cells on a worksheet. Tell users what data to put in the cells.
Explanation:
Choose a few cells on a worksheet. Tell users what data to put in the cells.
When the program runs, grab data like this:
Dim amount As Single
...
amount = Cells(1, 2)The first parameter to Cells is the row. The second is the column.