Visual basic screenupdating

Hence, what I did is to follow tjeffryes' recommendation and created a new watch on any variable.I set it to "All procedures" and "All modules" for the context, ran the procedure as usual in debug mode, then deleted the watch, closed the VB Code editor, and it was back to normal, the screen not being updated as my code was stating properly! I was able to solve my issue by deleting the Application. It appears that there is no single solution to this problem.

visual basic screenupdating-3

Enable Events" was changing from True to False, so all the people who say that in debug mode it never changes, this is not right to say that!

Yes indeed, the screen continues to be updated so that you can see the changes happen, but the value of this variable DOES CHANGE effectively. YES I remember that when I brought the last change to my code, I had indeed set a watch, but since I am working on customizing the ribbon, I save and close very often my excel file and I have certainly not deleted all the watches before posting my updates to prod.

Although I'm using VBA, not VB, I experienced the same symptoms when using Application.

Screen Updating = False , and this is how I solved it: I found that Application.

Screen Updating" not changing from True to False (thus being TRUE before and staying to TRUE right after the "Application.

Screen Updating = False" statement) while the "Application.

A recent example: My coworker uses a macro to open a sheet, searches through that sheet and activates the found cell, look at it's offset and determines if it meets criteria.

If the criteria is met, then 4 arrays are filled in all using and it does this for 24 rows.

However, I *can* change the Screen Updating from the immediate window. Screen Updating = False b Global Change Event = True Application. About to go home for the day, but I plan on trying to print Application. So while Screen Updating always is True in debug mode, this is not the issue for me.

Sub load Portfolio() Dim i Test As Integer, portfolio Version As String Application. :-) Basically, after all those statements (and between each one) Screen Updating remains "True". Screen Updating = False For i = 1 To 10000 Worksheets("Sheet1"). Screenupdating = False worked perfectly in Excel 2007 until last week, when it remained True however many times I tried to set it to False.

In one particular instance I found an interesting fix: I had a Watch set.

Tags: , ,