View Full Version : difference between
mokhtar
04-25-2015, 01:00 PM
Hello all
is there a difference between :Application.ScreenUpdating=False
and Debug.Assert Application.ScreenUpdating
Thanks in advance
mancubus
04-25-2015, 02:26 PM
hi.
Application.ScreenUpdating=False is used to stop screen flickering when the macro is running.
Debug.Assert is used debug the code. when the logical test value is false it will pause the code.
so they are different things.
try these codes:
Sub test1()
Debug.Assert Application.ScreenUpdating
MsgBox Application.ScreenUpdating
End Sub
Sub test2()
Application.ScreenUpdating = False
Debug.Assert (Application.ScreenUpdating)
MsgBox Application.ScreenUpdating
End Sub
mokhtar
04-25-2015, 02:48 PM
Thanks for the reply mr.mancubus
Regards
mokhtar
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.