Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving text around cells without moving boarder lines | Excel Discussion (Misc queries) | |||
Moving Data between sheets in the same workbook and moving data between Workbooks. | Excel Worksheet Functions | |||
Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) | |||
How to pick one or more items out of a list, moving to new list, moving up or down. (form) | Excel Discussion (Misc queries) |