+ Reply to Thread
Results 1 to 3 of 3

Pause Loop

  1. #1
    Registered User
    Join Date
    02-15-2006
    Posts
    93

    Pause Loop

    Good morning all,

    I have a macro that includes a loop. The loop changes some data but allows the user to watch the changes. What I would like to do is allow the user to pause the loop if there is something that they notice and would like to explore further but also allow the user to continue once they are finished looking it it. Not really sure how to accomplish this. I was thinking something like:

    Please Login or Register  to view this content.
    Any help would be greatly appreciated!
    thanks
    tc

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    I don't think you will be able to this. How can user's see what is happening during the code?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862
    I think he means that the user can see what's changing on the screen rather than in the code ... But - toocold - I'm not sure if you realise this or not, but the changes will be done way too fast for a user to see / react to them. If you do mean pause the code (not for users, mind you) then the Esc button is your friend.
    MatrixMan.
    --------------------------------------
    If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
    If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Error With a Do Until Loop
    By kevb8ll in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-01-2008, 04:35 PM
  2. Programming a Find Loop?
    By mcbain in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-21-2008, 04:44 AM
  3. Do Loop Until Loop
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-12-2007, 10:20 AM
  4. For type loop verse Do type loop
    By boylejob in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-09-2007, 03:02 PM
  5. Extend Loop From Within ?
    By Blewyn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-26-2007, 05:34 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1