+ Reply to Thread
Results 1 to 7 of 7

Abort button for a macro(not the break key) and pause/resume button

  1. #1
    Forum Contributor
    Join Date
    01-13-2009
    Location
    Mumbai
    MS-Off Ver
    Excel 2003, 2007
    Posts
    168

    Abort button for a macro(not the break key) and pause/resume button

    Hi all,
    I was wondering if i can put an abort button on the progress bar (or any userform) on pressing which the macro could be aborted.

    Does anyone know if it is possible?

    Regards,
    Vaibhav
    Last edited by c.vaibhav; 05-20-2009 at 02:26 PM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Abort button for a macro(not the break key)

    Which prgrees bar?
    Hope that helps.

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

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    01-13-2009
    Location
    Mumbai
    MS-Off Ver
    Excel 2003, 2007
    Posts
    168

    Re: Abort button for a macro(not the break key)

    I am using a progress bar to demonstrate the progress of my macro.. It is just a normal userform with a label whose width keeps on increasing as the macro keeps progressing..

    Anyways, my question is: can we have an Abort button on any userform with a code that it stops the running macro..

    Just adding a little more to this. Is it possible to Pause and Resume a macro through a button..

    thanks a lot.. i appreciate the help..

    regards,
    Vaibhav

  4. #4
    Forum Contributor
    Join Date
    01-13-2009
    Location
    Mumbai
    MS-Off Ver
    Excel 2003, 2007
    Posts
    168

    Re: Abort button for a macro(not the break key)

    Any suggestions are highly appreciated

    --Vaibhav

  5. #5
    Forum Contributor
    Join Date
    01-13-2009
    Location
    Mumbai
    MS-Off Ver
    Excel 2003, 2007
    Posts
    168

    Re: Abort button for a macro(not the break key)

    Hi Friends,

    I got a piece of code in another forum.. it goes as follows..

    Please Login or Register  to view this content.
    I think this will work for me.. i'll let you know if I get any problem with this one..

    Only the last part which also important for my project.. Can I add a Pause/Resume toggle button that will temporarily pause the macro at a particular step and after pressing it again it will resume the execution of macro from that step..

    Thanks,
    Vaibhav

  6. #6
    Forum Contributor
    Join Date
    01-13-2009
    Location
    Mumbai
    MS-Off Ver
    Excel 2003, 2007
    Posts
    168

    Re: Abort button for a macro(not the break key) and pause/resume button

    No Response yet!!!

  7. #7
    Forum Contributor
    Join Date
    01-13-2009
    Location
    Mumbai
    MS-Off Ver
    Excel 2003, 2007
    Posts
    168

    Re: Abort button for a macro(not the break key) and pause/resume button

    I have also posted the same question at

    http://www.mrexcel.com/forum/showthr...10#post1943810

    Regards,
    Vaibhav

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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