Screenupdating

[confusion123]

The code below is in a worksheet.

When I put in a breakpoint as shown, why is ScreenUpdating set to TRUE, when I specifically set it to False?

Private Sub Worksheet_Change(ByVal Target As Range)

Application.ScreenUpdating = False

Dim a As Integer

a = 10 'BREAKPOINT SHOWS Application.ScreenUpdating = TRUE!!!

Application.ScreenUpdating = True

End Sub

 

[Snakehips]

con123,

It shouldn't be true and it probably isn't.

If you are checking its state in the Immediate pane with ?Application.ScreenUpdating then it will say True

Try testing with MsgBox or Debug.Print as below.

Private Sub Worksheet_Change(ByVal Target As Range)
'MsgBox Application.ScreenUpdating
Debug.Print Application.ScreenUpdating
Application.ScreenUpdating = False


Dim a As Integer
Debug.Print Application.ScreenUpdating
'MsgBox Application.ScreenUpdating
a = 10 'BREAKPOINT SHOWS Application.ScreenUpdating = TRUE!!!
'MsgBox Application.ScreenUpdating
Debug.Print Application.ScreenUpdating
Application.ScreenUpdating = True


End Sub

Hope that helps.

 

[confusion123]

Thanks.

Yes, indeed I was "checking" using

? Application.Screenupdating

Your suggestion shows False, as it should be, so any ideas why using the Immediate window shows True?

 

[Snakehips]

I'm sorry but I have no idea as to why this is the case.

Even if you set Application.ScreenUpdating = False from within the Immediate window it still returns True if you query it from Immediate.

If you find an explanation then please post back.