Application.ScreenRefresh

If you want to turn screen updating on for a single instruction and then immediately turns it off again.
This makes it useful when you want the UI to reflect a change without fully re-enabling live updates.
When you've disabled screen updating for performance but need the user to see a specific change (e.g., inserting text, moving the selection, updating fields)

Excel

The method Application.ScreenRefresh does not exist in Excel.
The equivalent can be accomplished using DoEvents.

Word

Application.ScreenRefresh is a Word-specific VBA method that forces a one-time screen update even when Application.ScreenUpdating = False

Application.ScreenUpdating = False 
'code that changes the document
Application.ScreenRefresh   'forces a one-time UI update  
'more code
Application.ScreenUpdating = True 

PowerPoint

The method Application.ScreenRefresh does not exist in PowerPoint.