Prevent Screen from flicking from one place to the next

[skuzapo]

Hi,

I have a userform with a calculation on it. Once the user is satisfied with the result they push a button and the results of the calculations are copied from one sheet into a data list on another sheet.

The problem is that while excel is busy copying, pasting and clearing the contents of cells ready for the next calculation, the user can see all of this in the background as ranges are highlighted etc.

Is there any way to prevent this from happening so that the code still executes but the user can't watch it happening?

Later on I'd also like to add a status bar to the form to show that something is happening once the button has been clicked.

Thanks for any advice
Cheers

[Paul B]

skuzapo,

Application.ScreenUpdating = False
'your code
Application.ScreenUpdating = True


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"skuzapo" <skuzapo.24bwem_1141783801.6328@excelforum-nospam.com> wrote in
message news:skuzapo.24bwem_1141783801.6328@excelforum-nospam.com...
>
> Hi,
>
> I have a userform with a calculation on it. Once the user is satisfied
> with the result they push a button and the results of the calculations
> are copied from one sheet into a data list on another sheet.
>
> The problem is that while excel is busy copying, pasting and clearing
> the contents of cells ready for the next calculation, the user can see
> all of this in the background as ranges are highlighted etc.
>
> Is there any way to prevent this from happening so that the code still
> executes but the user can't watch it happening?
>
> Later on I'd also like to add a status bar to the form to show that
> something is happening once the button has been clicked.
>
> Thanks for any advice
> Cheers
>
>
> --
> skuzapo
> ------------------------------------------------------------------------
> skuzapo's Profile:
http://www.excelforum.com/member.php...o&userid=27430
> View this thread: http://www.excelforum.com/showthread...hreadid=519966
>

[JMB]

As for the statusbar

Application.StatusBar = "Hello There!"

Then, to reset it at the end of your code

Application.StatusBar = False


"skuzapo" wrote:

>
> Hi,
>
> I have a userform with a calculation on it. Once the user is satisfied
> with the result they push a button and the results of the calculations
> are copied from one sheet into a data list on another sheet.
>
> The problem is that while excel is busy copying, pasting and clearing
> the contents of cells ready for the next calculation, the user can see
> all of this in the background as ranges are highlighted etc.
>
> Is there any way to prevent this from happening so that the code still
> executes but the user can't watch it happening?
>
> Later on I'd also like to add a status bar to the form to show that
> something is happening once the button has been clicked.
>
> Thanks for any advice
> Cheers
>
>
> --
> skuzapo
> ------------------------------------------------------------------------
> skuzapo's Profile: http://www.excelforum.com/member.php...o&userid=27430
> View this thread: http://www.excelforum.com/showthread...hreadid=519966
>
>

[JMB]

Sorry - you said add a statusbar to the form. My suggestion would use Excels
statusbar at the bottom left of the screen.



"skuzapo" wrote:

>
> Hi,
>
> I have a userform with a calculation on it. Once the user is satisfied
> with the result they push a button and the results of the calculations
> are copied from one sheet into a data list on another sheet.
>
> The problem is that while excel is busy copying, pasting and clearing
> the contents of cells ready for the next calculation, the user can see
> all of this in the background as ranges are highlighted etc.
>
> Is there any way to prevent this from happening so that the code still
> executes but the user can't watch it happening?
>
> Later on I'd also like to add a status bar to the form to show that
> something is happening once the button has been clicked.
>
> Thanks for any advice
> Cheers
>
>
> --
> skuzapo
> ------------------------------------------------------------------------
> skuzapo's Profile: http://www.excelforum.com/member.php...o&userid=27430
> View this thread: http://www.excelforum.com/showthread...hreadid=519966
>
>

[skuzapo]

Thank you very much for your useful input.
Cheers