From the course: Excel: Learning VBA

Unlock the full course today

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

Solution: Add advanced elements to your workbook

Solution: 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

Solution: Add advanced elements to your workbook

“

(upbeat music) - [Instructor] In the previous movie, I gave you a set of challenges using skills that you learned in this chapter and in this movie I will show you how I might solve them. My sample file is 06 06 solution a nd you can find it in the chapter six folder of the exercise files collection. So again, on sheet one I have a suggestion box form and then when the as suggestion macro is run after it's been updated, it will write the values to sheet two and then on sheet three I have a list of data that we'll use in a moment. So I'll switch back to sheet one and press Alt F 11 to open the Visual Basic Editor and here I have add suggestion and the code that you use to turn off screen updating is application.screenupdating equals false and then the code at the bottom will turn it back on by setting the value to true. Excel is pretty good about turning screen updating back on. However, I find it's a good programming…

Contents