Vba application screenupdating off

By turning off the screen updating your macros will run much faster.

Raise Number:=vb Object Error ERR_VERSION_NOT_SUPPORTED, _ Description:="Newer version." Exit Property End Select If hwnd = 0 Then Err.' -------------------------------------------------------------------------------- ' Copyright 1999-2015, Shyam Pillai, All Rights Reserved.' -------------------------------------------------------------------------------- ' You are free to use this code within your own applications, add-ins, ' documents etc but you are expressly forbidden from selling or ' otherwise distributing this source code without prior consent.Then the form gets loaded but because the screenupdating is off, it just shows up white (not readable). At this point in the code, all of the code starts executing but at certain points in the code I was hoping to just update the form and change the labels from "Running..." to "Complete! The problem is that I can change them in the code, but the user won't see the changes because the screen is not being updated.I would like to keep the excel screen from being updated but refresh the form along the way. Hope that Helps Roy New users should read the Forum Rules before posting For free Excel tools & articles visit my web site If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need Roy UK's Web Site roy UK's Database Form Where to paste code from the Forum About me.

Leave a Reply

  1. I want sex no signup free 05-Apr-2016 18:17

    A 40 year old should not date younger than a 27 year old. It's an important age/stage to go through, in my opinion.