Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
screenupdating = true
Hi,
is anyone aware of whether Application.ScreenUpdating = True also updates settings on objects created using the control toolbox)? I am running into a problem where not everything on the screen updates all the time and from the pattern I am noticing, it seems that it always shows changes in the worksheet itself, but sometimes does not show changes to objects on the worksheet. Details: My program runs in two modes - "one screen at a time" or "loop through many screens." I set screenupdating to false no matter what. In "one screen at a time" mode, everything displays as it should at the end of each run. In this mode I don't explicitly update the screen but rely instead on the fact that the screen updates when the sub ends. In "loop through many screens" mode, I have the "do work" sub called from a looping macro. Now I explicitly state screenupdating = true at the end of each loop and I have a "wait" function that halts the running of the macro allows one to see the display for a short while. All the changes occur (I stepped through the code), but the display is not right. The worksheet changes are there, but changes made to something like the caption of a toggle button do not display. My code is extremely long and and won't run without the data residing in the worksheet. So I can't post it all. I am quite certain, however, that the problem has nothing to do with the code since everything works right when I step through the code. (In step into mode, the screen of course updates properly as it always does.) Is anyone out there aware of what the issue might be and how I might be able to fix it? -- eugene |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
ScreenUpdating stays TRUE no matter what? | Excel Programming | |||
Screenupdating is always true | Excel Programming | |||
ScreenUpdating automatically resets to True | Excel Programming |