Then you can turn screen updating on to update the screen.
Clear Contents s Conn Params = "ODBC; DSN=MS Access Database;" & _ "DBQ=" & db Path & db File & ";" & _ "Default Dir=" & db Path & ";" & _ "Driver Id=25;" & _ "FIL=MS Access;" & _ "Max Buffer Size=2048;" & _ "Page Timeout=5;" & _ "Destination:=Sheet11.range(""J1""))" s SQL = "SELECT DISTINCT [Staff Team] FROM " & db Name & " WHERE (" & db Name & ". Refresh Background Query:=False End With Range("J1"). Every time I select a value in the listbox, the screen "flickers" to the hidden worksheet. I want to be able to do the whole process without that "flickering". 460281-Application-Screen Updating-false-does-not-work Hi, I've got a listbox which populates a second listbox from cells on a hidden worksheet which is done through macros. If a program neglects to turn screen updating on after turning it off, the Visio instance turns screen updating back on when a user performs an operation.Note The Show Changes and Screen Updating properties are similar in that they are both designed to increase performance during a series of actions, but they work differently.The silly code I presented in the Screen Updating Demonstration just numbers cells. Screen Updating=False are presented below: Ryan Wells is a Nuclear Engineer and professional VBA Developer.He is the lead developer of several VBA products, including Mouse To Macro. 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.