From the course: Excel: Learning VBA

Unlock the full course today

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

Challenge: Add advanced elements to your workbook

Challenge: Add advanced elements to your workbook - Microsoft Excel Tutorial

From the course: Excel: Learning VBA

Start my 1-month free trial Buy for my team

Challenge: Add advanced elements to your workbook

“

(upbeat music) - [Instructor] Now that we've reached the end of the chapter, I wanted to present a challenge so you can practice the skills that you've learned. And these will be related to adding advanced elements to your VBA code. So the challenges are to turn off screen updating and that is to prevent any flashing that might occur and it could be distracting. Also, I'll ask you to use worksheet functions in a macro, to acquire values using an input box, and finally to call a subroutine from another subroutine. So there are four challenges, but a couple of them just require one or two lines of code. As with the other challenges in this course, there are three aspects to it. The first is to prepare by reading the comments in each code module. Second is to create your solution by adding two or editing existing code. And finally, to test your solution to make sure it runs as expected. With all that in mind, I'll…

Contents