Excel VBA Programming The Complete Guide - The Application.ScreenUpdating Property

Excel VBA Programming The Complete Guide - The Application.ScreenUpdating Property

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Wayground Content

FREE Resource

The video tutorial explains the screen updating property in Excel macros, which can be set to false to improve execution speed by batching updates. It demonstrates creating a times table using nested loops, highlighting the importance of disabling screen updating for performance. The tutorial walks through the process of setting up the procedure, implementing nested loops, and executing the macro to observe the results. The key advantage is the significant speed improvement by avoiding constant screen updates.

Read more

1 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What new insight or understanding did you gain from this video?

Evaluate responses using AI:

OFF

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?