From the course: Excel: Learning VBA

Unlock the full course today

Join today to access over 24,000 courses taught by industry experts.

Challenge: Define variables, constants, and calculations

Challenge: Define variables, constants, and calculations - Microsoft Excel Tutorial

From the course: Excel: Learning VBA

Start my 1-month free trial Buy for my team

Challenge: Define variables, constants, and calculations

“

(light electronic music) - [Instructor] Now that we've reached the end of the chapter, I wanted to give you a challenge so that you can test the skills that you learned. And I'm looking at defining variables, constants, and calculations. So here is the challenge. I want you to: declare variables and use them in procedures, create calculations using built-in operators, declare and move through a five-item array, and finally, declare and use an object variable. There will be three steps. The first is I'll ask you to prepare. Read the comments in each code module to learn about the challenge. Then create. Add to or edit the existing code to create a solution that meets the challenge. And finally, test your solution. Run your code to make sure it works as expected. I'll switch over to Excel now to show you the sample file that you will use. The file I would like you to work with is 02_09_Challenge, and you can find…

Contents