Share via

ScreenRefresh Method

  • Article

Updates the display on the monitor with the current information in the video memory buffer. You can use this method after using the ScreenUpdating property to disable screen updates.

expression**.ScreenRefresh**

expression Required. An expression that returns an Application object.

Remarks

ScreenRefresh turns on screen updating for just one instruction and then immediately turns it off. Subsequent instructions don't update the screen until screen updating is turned on again with the ScreenUpdating property.

Example

This example turns off screen updating, opens Test.doc, inserts text, refreshes the screen, and then closes the document (with changes saved).

Dim rngTemp As Range

ScreenUpdating = False
Documents.Open FileName:="C:\DOCS\TEST.DOC"

Set rngTemp = ActiveDocument.Range(Start:=0, End:=0)

rngTemp.InsertBefore "new"
Application.ScreenRefresh
ActiveDocument.Close SaveChanges:=wdSaveChanges
ScreenUpdating = True

Applies to | Application Object

See Also | ScreenUpdating Property