Consulting

Results 1 to 4 of 4

Thread: Solved: Switching off background actions.

  1. 05-15-2006, 12:20 AM #1
    WebGuy
    WebGuy is offline
    VBAX Regular
    Joined
    May 2006
    Posts
    33
    Location

    Solved: Switching off background actions.

    Hi!
    Since i am very new to VB my knowlege is very limited. I have however managed to use vb to script a few helpful programs(mainly sort& select routines).
    My question is regarding one of my sort & select routines. My script adds, subtracts, multiplies and summarizes thousands of values in 3 different sheets. This means that there is a lot of jumping between sheets. I an trying to find a way to do all the sheet jumping and calculating in the background while only showing the main sheet. Does anyone know if this is possible.
    //Henry VBRookie
    Reply With Quote Reply With Quote
  2. 05-15-2006, 12:24 AM #2
    johnske
    johnske is offline
    Administrator
    Chat VP     VBAX Guru johnske's Avatar
    Joined
    Jul 2004
    Location
    Townsville, Australia
    Posts
    2,872
    Location
    Put Application.ScreenUpdating = False at the head of your code and Application.ScreenUpdating = True at the end of it

    Oh, I just noticed ... and welcome to VBAX
    You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you

    The major part of getting the right answer lies in asking the right question...


    Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
    Reply With Quote Reply With Quote
  3. 05-15-2006, 12:39 AM #3
    WebGuy
    WebGuy is offline
    VBAX Regular
    Joined
    May 2006
    Posts
    33
    Location
    Thank you very much !
    That worked perfectyly, now i dont have to watch thousands of numbers flashing by !
    Reply With Quote Reply With Quote
  4. 05-15-2006, 01:01 AM #4
    johnske
    johnske is offline
    Administrator
    Chat VP VBAX Guru johnske's Avatar
    Joined
    Jul 2004
    Location
    Townsville, Australia
    Posts
    2,872
    Location
    Not a prob.
    You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you

    The major part of getting the right answer lies in asking the right question...


    Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules