Moving di

[michael.beckinsale]

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

 

[Jim Thomlinson]

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.

 

[michael.beckinsale]

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







- 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