Caption) 'lng Handle = Find Window(vb Null String, Application.hi all, does anyone know how to mimic application.screenupdating = false in access vba? Here is a variable to store the handle: Dim lng Handle As Long 'lockwindowupdate returns a zero if it failed, so heres a container for checking 'the return Dim Ret As Long 'we'll use this in the "error trap" Dim bln Tried Already As Boolean 'To find the handle for the Project window we'll use the Find Window function, again part 'of the Win32 API.This function accepts two arguments, the Classname and the caption of the window 'I have Project 2002, the class name of the MS Project window is JWinproj-Whimper Main Class 'I have no idea what it might be for other versions of Project. Then comment out the line which turns off screen updating and see what happens; you should find that you scroll down the sheet as the numbers get filled.
lng Handle = Find Window("JWinproj-Whimper Main Class", Application.I don't want users to see the screen 'flicking' around as the code moves between cells and worksheets Any help gratefully recieved Dan Dan Auber Dan [email protected], The code to stop the screen updating is Application. Msg Box "Macro complete", vb OKOnly vb Information, "Title"Application.Screen Updating = False Try it in combination with these lines: Application. Screen Updating = True Just some additional info: If you want to do this in VBA for Access, the command is: Do Cmd.Here are the example codes to control the Events, Screen Updating, Progress Bar, Display Alerts and other Application Objects.This will help you to write Optimized VBA Code to fasten your code and build better VBA Macro Applications. Enable Events = False 'Do your Task 'changing combo box combo1.