Vba screen updating code dating kp

Posted by / 26-Aug-2017 13:54

Vba screen updating code

I have changed it slightly so it loops 10,000 times and I execute it 10 times for sample size.

Screen Updating=False This will stop Excel having to repaint the screen each time the macro does something.

I would like the queries to be invisible while they are running, but currently the user sees 50 query windows open/close which is ugly.

Is there a way to automatically minimize/hide query windows or disable screen update?

A form's Resize event as well as firing when a user resizes a form, also fires when a form is loaded.

For example, this code will resize a sub-form within a resized form: [font=Verdana][size=2]You should not have to do all that.

vba screen updating code-60vba screen updating code-78vba screen updating code-73

One thought on “vba screen updating code”