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!

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!

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!

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!

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!

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

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

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