PDA

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