Excel VBA Introduction Part 40 - Disabling Screen Updates

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link www.wiseowl.co... to make a donation. Thanks for watching!
You can buy our Introduction to Excel VBA book here www.lulu.com/s...
By Andrew Gould
www.wiseowl.co.uk - You can give your VBA code a quick performance boost by simply disabling screen updates while your code runs. This video explains how to achieve that, as well as how to create a basic timer system to test the results.
You can download the example file for this video here:
www.wiseowl.co...
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more

[@Gk2810_]

i know screen updating = false since a year thanks to you ... but i love "time taken" hack . thank you sir ... very informative ....

[@imranbhatti8580]

I used to think about this piece of code in excel vba "Screen updating=false or true ,,what was it....but after watching this video my concept is cleared ...Thanks wise owl

[@divyal5852]

This is one of my favourites! Thank you very much Andrew!

[@kumkumsaini5590]

Fantastic video ever, There is no second module available in file with data to download please share it.

[@peterhontaru5537]

Fantastic video as always - thank you!

[@ElonMuchen3737]

Andrew, thanks for sharing your knowledge. You are a great teacher!
I have a question. Is there someway to put a kind of timer to start a sequence of codes after a specific time? Sorry for my English.

[@janezklun]

great video, thank you for sharing

[@DennisYeadon]

Andrew, you have created an excellent series of videos. Thank you so much. I have just one question at this time. Where may I find the movies workbook? Again, thank you for all your help as I learn VBA.

[@AubreyGreenJr]

If you add a screenupdating = true at the end then you would not have to end the macro to see the result. Or did you have to leave it to see the time? Ohterwise, nice tutorial...

[@danielmwippel]

If I don't turn screen update on again at the end of the sub routine will it be enabled automatically?

[@WiseOwlTutorials]

Hi Daniel, Microsoft's recommendation is to switch it back on docs.microsoft.com/en-us/office/vba/api/excel.application.screenupdating#remarks

[@Ronnet]

Great video! But the link in the description doesnt work

[@Ronnet]

***** Thank you for the quick response and the file! And of course a much bigger thanks for all these very well made videos. They're the best videos I've found on RUclips about VBA by a mile!