Moving di
 

Hi All,

Quite frequently l find that when l use vba to launch a custom form or
built in dialog box such as save / saveas and then move it from the
centre of the screen it leaves a 'gray trail' behind it.

Does anybody know whats causing it and how to avoid it?

TIA

Regards

Michael Beckinsale

Moving di
 

As a guess your screen updating is off... Try turning it on just before you
display your form. Note that this meand you don't want to have a bunch of
sheet and cell selects in your code.
--
HTH...

Jim Thomlinson


"michael.beckinsale" wrote:

Hi All,

Quite frequently l find that when l use vba to launch a custom form or
built in dialog box such as save / saveas and then move it from the
centre of the screen it leaves a 'gray trail' behind it.

Does anybody know whats causing it and how to avoid it?

TIA

Regards

Michael Beckinsale

Moving di
 

On 10 May, 16:11, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
As a guess your screen updating is off... Try turning it on just before you
display your form. Note that this meand you don't want to have a bunch of
sheet and cell selects in your code.
--
HTH...

Jim Thomlinson



"michael.beckinsale" wrote:
Hi All,

Quite frequently l find that when l use vba to launch a custom form or
built in dialog box such as save / saveas and then move it from the
centre of the screen it leaves a 'gray trail' behind it.

Does anybody know whats causing it and how to avoid it?

TIA

Regards

Michael Beckinsale- Hide quoted text -

- Show quoted text -

Hi Jim,

Many thanks, it really was that simple!

It always amazes me how one tends to look for the complicated solution
when the answer is staring you in the face.

Regards

Michael beckinsale