Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent Screen from flicking from one place to the next
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent Screen from flicking from one place to the next
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent Screen from flicking from one place to the next
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent Screen from flicking from one place to the next
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent Screen from flicking from one place to the next
Thank you very much for your useful input. Cheers -- skuzapo ------------------------------------------------------------------------ skuzapo's Profile: http://www.excelforum.com/member.php...o&userid=27430 View this thread: http://www.excelforum.com/showthread...hreadid=519966 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I lock a screen to prevent scrolling? | Excel Discussion (Misc queries) | |||
Can't eliminate flicking of chart on every calculate | Charts and Charting in Excel | |||
prevent big white screen | Excel Worksheet Functions | |||
Prevent UserForm on top of a worksheet from being dragged around screen | Excel Programming | |||
How to position form in same place with different screen resolutions | Excel Programming |