screen flashing on macros
screen flashing on macros
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: screen flashing on macros

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    hi, ive got a macro to add data from one sheet to another, and i know there is a line to put at the top of the macro to stop the screen flashing, but i cant remember what it it (something like "screen update" or something)
    so if anyone could tell me the line, ide be very gratefull

    thanx BoB

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Application.ScreenUpdating=False

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Keaau, Hawaii
    Posts
    238
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just make sure to put:

    Application.ScreenUpdating = True

    as the last line of your code or the screen could remain blank when the macro is done running!!

    Yours in EXCELent Frustration
    KniteMare

  4. #4
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-04-01 07:29, KniteMare wrote:
    Just make sure to put:

    Application.ScreenUpdating = True

    as the last line of your code or the screen could remain blank when the macro is done running!!

    Yours in EXCELent Frustration
    KniteMare
    So long as control is returned to Excel at the end of the code, you don't need to put this line in.

    for example, if you push a button on a userform to perform some operation that turns off screen updates, when control returns to the userform you will be able to drag it all over your screen and paint pretty Userform pictures all over it.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com