| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Flickering screen while processing macro
Based on input from the User, a macro takes data from several worksheets and
inputs the data to a form which then is further updated by the user. The screen flickers as the program copies and pastes data. Is there some way to mask the flicker by using a "splash screen" (if I am using the term properly), which would disappear when the update is completed? The displayed message would read: "Please wait while CAIS is being created" and also include a creation graphic that I have. Thanks in advance! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Flickering screen while processing macro
Try
Application.screenupdating = false your code Application.screenupdating=true Mike "Pa Maher" wrote: Based on input from the User, a macro takes data from several worksheets and inputs the data to a form which then is further updated by the user. The screen flickers as the program copies and pastes data. Is there some way to mask the flicker by using a "splash screen" (if I am using the term properly), which would disappear when the update is completed? The displayed message would read: "Please wait while CAIS is being created" and also include a creation graphic that I have. Thanks in advance! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Flickering screen while processing macro
Try this:
Application.ScreenUpdating = FALSE .....run your code.... Application.ScreenUpdating = TRUE If the process may take a while, consider using the Status Bar to display progress: Application.StatusBar = "Processing sheet 3 of 12" Return it to the default behavior with: Application.StatusBar = FALSE Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Pa Maher" wrote in message ... Based on input from the User, a macro takes data from several worksheets and inputs the data to a form which then is further updated by the user. The screen flickers as the program copies and pastes data. Is there some way to mask the flicker by using a "splash screen" (if I am using the term properly), which would disappear when the update is completed? The displayed message would read: "Please wait while CAIS is being created" and also include a creation graphic that I have. Thanks in advance! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Flickering screen while processing macro
at the top of the macro put in
Application.ScreenUpdating = False at the end of the macro Application.ScreenUpdating = true if you really want a splash screen: http://www.j-walk.com/ss/excel/tips/tip39.htm maybe combined with http://www.j-walk.com/ss/excel/tips/tip34.htm If your code has command like worksheets("Sheet1").Activate range("A1").Select selection.Copy worksheets("Summary").activate Range("B9").Select Activesheet.Paste that could be done with worksheets("Sheet1").Range("A1").copy Worksheets("Summary").Range("B9") or if you only need the contents of the cell and not the formatting Worksheets("Summary").Range("B9").Value = _ worksheets("Sheet1").Range("A1").Value These types of commands are silent. IF Summary was the activesheet and range B9 was in view, you would see its value change, but if some other sheet was active, you would see very little. -- Regards, Tom Ogilvy "Pa Maher" wrote: Based on input from the User, a macro takes data from several worksheets and inputs the data to a form which then is further updated by the user. The screen flickers as the program copies and pastes data. Is there some way to mask the flicker by using a "splash screen" (if I am using the term properly), which would disappear when the update is completed? The displayed message would read: "Please wait while CAIS is being created" and also include a creation graphic that I have. Thanks in advance! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Flickering screen while processing macro
Tom I'm working on a new project.
In this case I want to copy the format. When I use worksheets("Sheet1").Range("A1").copy Worksheets("Summary").Range("B9") the text is copied but the green fill and bold text is not "Tom Ogilvy" wrote: at the top of the macro put in Application.ScreenUpdating = False at the end of the macro Application.ScreenUpdating = true if you really want a splash screen: http://www.j-walk.com/ss/excel/tips/tip39.htm maybe combined with http://www.j-walk.com/ss/excel/tips/tip34.htm If your code has command like worksheets("Sheet1").Activate range("A1").Select selection.Copy worksheets("Summary").activate Range("B9").Select Activesheet.Paste that could be done with worksheets("Sheet1").Range("A1").copy Worksheets("Summary").Range("B9") or if you only need the contents of the cell and not the formatting Worksheets("Summary").Range("B9").Value = _ worksheets("Sheet1").Range("A1").Value These types of commands are silent. IF Summary was the activesheet and range B9 was in view, you would see its value change, but if some other sheet was active, you would see very little. -- Regards, Tom Ogilvy "Pa Maher" wrote: Based on input from the User, a macro takes data from several worksheets and inputs the data to a form which then is further updated by the user. The screen flickers as the program copies and pastes data. Is there some way to mask the flicker by using a "splash screen" (if I am using the term properly), which would disappear when the update is completed? The displayed message would read: "Please wait while CAIS is being created" and also include a creation graphic that I have. Thanks in advance! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Flickering screen while processing macro
This should do what you want: Code: -------------------- Worksheets("Sheet1").Range("A1").Copy Worksheets("Summary").Range("B9").PasteSpecial Paste:=xlPasteAll -------------------- Pa Maher;472008 Wrote: Tom I'm working on a new project. In this case I want to copy the format. When I use worksheets("Sheet1").Range("A1").copy Worksheets("Summary").Range("B9") the text is copied but the green fill and bold text is not "Tom Ogilvy" wrote: at the top of the macro put in Application.ScreenUpdating = False at the end of the macro Application.ScreenUpdating = true if you really want a splash screen: 'Excel Developer Tip: Creating a \"Splash Screen\" for a Workbook' (http://www.j-walk.com/ss/excel/tips/tip39.htm) maybe combined with http://www.j-walk.com/ss/excel/tips/tip34.htm If your code has command like worksheets("Sheet1").Activate range("A1").Select selection.Copy worksheets("Summary").activate Range("B9").Select Activesheet.Paste that could be done with worksheets("Sheet1").Range("A1").copy Worksheets("Summary").Range("B9") or if you only need the contents of the cell and not the formatting Worksheets("Summary").Range("B9").Value = _ worksheets("Sheet1").Range("A1").Value These types of commands are silent. IF Summary was the activesheet and range B9 was in view, you would see its value change, but if some other sheet was active, you would see very little. -- Regards, Tom Ogilvy "Pa Maher" wrote: Based on input from the User, a macro takes data from several worksheets and inputs the data to a form which then is further updated by the user. The screen flickers as the program copies and pastes data. Is there some way to mask the flicker by using a "splash screen" (if I am using the term properly), which would disappear when the update is completed? The displayed message would read: "Please wait while CAIS is being created" and also include a creation graphic that I have. Thanks in advance! -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=130406 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Flickering screen while processing macro
The actual code I used is
Worksheets("Source").Range("A9:B9").Copy Worksheets("Quiz").Range("B9:C9")PasteSpecial Paste:=xlPasteAll I get an error message Compile error syntax error "Simon Lloyd" wrote: This should do what you want: Code: -------------------- Worksheets("Sheet1").Range("A1").Copy Worksheets("Summary").Range("B9").PasteSpecial Paste:=xlPasteAll -------------------- Pa Maher;472008 Wrote: Tom I'm working on a new project. In this case I want to copy the format. When I use worksheets("Sheet1").Range("A1").copy Worksheets("Summary").Range("B9") the text is copied but the green fill and bold text is not "Tom Ogilvy" wrote: at the top of the macro put in Application.ScreenUpdating = False at the end of the macro Application.ScreenUpdating = true if you really want a splash screen: 'Excel Developer Tip: Creating a \"Splash Screen\" for a Workbook' (http://www.j-walk.com/ss/excel/tips/tip39.htm) maybe combined with http://www.j-walk.com/ss/excel/tips/tip34.htm If your code has command like worksheets("Sheet1").Activate range("A1").Select selection.Copy worksheets("Summary").activate Range("B9").Select Activesheet.Paste that could be done with worksheets("Sheet1").Range("A1").copy Worksheets("Summary").Range("B9") or if you only need the contents of the cell and not the formatting Worksheets("Summary").Range("B9").Value = _ worksheets("Sheet1").Range("A1").Value These types of commands are silent. IF Summary was the activesheet and range B9 was in view, you would see its value change, but if some other sheet was active, you would see very little. -- Regards, Tom Ogilvy "Pa Maher" wrote: Based on input from the User, a macro takes data from several worksheets and inputs the data to a form which then is further updated by the user. The screen flickers as the program copies and pastes data. Is there some way to mask the flicker by using a "splash screen" (if I am using the term properly), which would disappear when the update is completed? The displayed message would read: "Please wait while CAIS is being created" and also include a creation graphic that I have. Thanks in advance! -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=130406 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Flickering screen while processing macro
You dropped a dot before the PasteSpecial.
Is that an error in your post or in your code? Pa Maher wrote: The actual code I used is Worksheets("Source").Range("A9:B9").Copy Worksheets("Quiz").Range("B9:C9")PasteSpecial Paste:=xlPasteAll I get an error message Compile error syntax error "Simon Lloyd" wrote: This should do what you want: Code: -------------------- Worksheets("Sheet1").Range("A1").Copy Worksheets("Summary").Range("B9").PasteSpecial Paste:=xlPasteAll -------------------- Pa Maher;472008 Wrote: Tom I'm working on a new project. In this case I want to copy the format. When I use worksheets("Sheet1").Range("A1").copy Worksheets("Summary").Range("B9") the text is copied but the green fill and bold text is not "Tom Ogilvy" wrote: at the top of the macro put in Application.ScreenUpdating = False at the end of the macro Application.ScreenUpdating = true if you really want a splash screen: 'Excel Developer Tip: Creating a \"Splash Screen\" for a Workbook' (http://www.j-walk.com/ss/excel/tips/tip39.htm) maybe combined with http://www.j-walk.com/ss/excel/tips/tip34.htm If your code has command like worksheets("Sheet1").Activate range("A1").Select selection.Copy worksheets("Summary").activate Range("B9").Select Activesheet.Paste that could be done with worksheets("Sheet1").Range("A1").copy Worksheets("Summary").Range("B9") or if you only need the contents of the cell and not the formatting Worksheets("Summary").Range("B9").Value = _ worksheets("Sheet1").Range("A1").Value These types of commands are silent. IF Summary was the activesheet and range B9 was in view, you would see its value change, but if some other sheet was active, you would see very little. -- Regards, Tom Ogilvy "Pa Maher" wrote: Based on input from the User, a macro takes data from several worksheets and inputs the data to a form which then is further updated by the user. The screen flickers as the program copies and pastes data. Is there some way to mask the flicker by using a "splash screen" (if I am using the term properly), which would disappear when the update is completed? The displayed message would read: "Please wait while CAIS is being created" and also include a creation graphic that I have. Thanks in advance! -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=130406 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blinking/flickering screen | Excel Discussion (Misc queries) | |||
| Excel 2003: Stop Screen flickering | Excel Programming | |||
| FLICKERING SCREEN WHEN WORKING | Excel Discussion (Misc queries) | |||
| Flickering of the Screen when the Macro runs. | Excel Programming | |||
| Screen flickering when updating textboxes | Excel Programming | |||
Linear Mode
