Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What does ScreenUpdating = False do?
I have "borrowed" subroutines from this site (that work beautifully) that have:
ScreenUpdating = False <code that changes the values of cells here ScreenUpdating = True I was wondering what setting the ScreenUpdating to false and back to true is doing for me. I looked in Excel help (it was no help). I would love a simple (I'm not an advanced user) explanation. Thank you, Judy |
#2
|
|||
|
|||
If your code changes worksheets or moves the screen (going to other cells), then
it hides those screen movements. It's less disturbing to the user and actually makes your code work faster. Judy Ward wrote: I have "borrowed" subroutines from this site (that work beautifully) that have: ScreenUpdating = False <code that changes the values of cells here ScreenUpdating = True I was wondering what setting the ScreenUpdating to false and back to true is doing for me. I looked in Excel help (it was no help). I would love a simple (I'm not an advanced user) explanation. Thank you, Judy -- Dave Peterson |
#3
|
|||
|
|||
Thank you very much for your reply. I was only using this in my borrowed
function; I can see that it would be a good idea to use it throughout my macros--except that my users are impressed by seeing the screen movements! Thank you, Judy "Dave Peterson" wrote: If your code changes worksheets or moves the screen (going to other cells), then it hides those screen movements. It's less disturbing to the user and actually makes your code work faster. Judy Ward wrote: I have "borrowed" subroutines from this site (that work beautifully) that have: ScreenUpdating = False <code that changes the values of cells here ScreenUpdating = True I was wondering what setting the ScreenUpdating to false and back to true is doing for me. I looked in Excel help (it was no help). I would love a simple (I'm not an advanced user) explanation. Thank you, Judy -- Dave Peterson |
#4
|
|||
|
|||
Will they be impressed as much when they have a fit?
Bob "Judy Ward" wrote in message ... Thank you very much for your reply. I was only using this in my borrowed function; I can see that it would be a good idea to use it throughout my macros--except that my users are impressed by seeing the screen movements! Thank you, Judy "Dave Peterson" wrote: If your code changes worksheets or moves the screen (going to other cells), then it hides those screen movements. It's less disturbing to the user and actually makes your code work faster. Judy Ward wrote: I have "borrowed" subroutines from this site (that work beautifully) that have: ScreenUpdating = False <code that changes the values of cells here ScreenUpdating = True I was wondering what setting the ScreenUpdating to false and back to true is doing for me. I looked in Excel help (it was no help). I would love a simple (I'm not an advanced user) explanation. Thank you, Judy -- Dave Peterson |
#5
|
|||
|
|||
Yeah. I often turn ScreenUpdating on once a row, or something, so it'll
look like it's doing something. It's like high-tech movies where they show a card sorter or an old tape drive. I've even thought about issuing beeps and boops as the code runs. The public expects it. -- Earl Kiosterud www.smokeylake.com/ ------------------------------------------- "Judy Ward" wrote in message ... Thank you very much for your reply. I was only using this in my borrowed function; I can see that it would be a good idea to use it throughout my macros--except that my users are impressed by seeing the screen movements! Thank you, Judy "Dave Peterson" wrote: If your code changes worksheets or moves the screen (going to other cells), then it hides those screen movements. It's less disturbing to the user and actually makes your code work faster. Judy Ward wrote: I have "borrowed" subroutines from this site (that work beautifully) that have: ScreenUpdating = False <code that changes the values of cells here ScreenUpdating = True I was wondering what setting the ScreenUpdating to false and back to true is doing for me. I looked in Excel help (it was no help). I would love a simple (I'm not an advanced user) explanation. Thank you, Judy -- Dave Peterson |
#6
|
|||
|
|||
Makes a better movie when the card sorter spews the cards up
into the air rather than down into slots. Not much interest in looking at square tapes that just sit there. "Earl Kiosterud" wrote in message ... Yeah. I often turn ScreenUpdating on once a row, or something, so it'll look like it's doing something. It's like high-tech movies where they show a card sorter or an old tape drive. I've even thought about issuing beeps and boops as the code runs. The public expects it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Grouped Sheets and Formating | Excel Discussion (Misc queries) | |||
link data to new workbook | Excel Discussion (Misc queries) | |||
Grand Totals @ Same Place | Excel Worksheet Functions |