+ Reply to Thread
Results 1 to 3 of 3

Run Macro, but switch into "F8" mode while it's running?

  1. #1
    Forum Contributor
    Join Date
    08-16-2010
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    132

    Run Macro, but switch into "F8" mode while it's running?

    Hi there - I have a long bit of code that I need to run, but I'm looking to test a section in the middle. I want the prior code to run, but F8ing through the whole thing would take me 20 minutes. I'm wondering if there is something I can put into the sheet that would allow me to "switch into F8 mode" once it hits that?

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Run Macro, but switch into "F8" mode while it's running?

    Hi lordterrin

    Try the
    Please Login or Register  to view this content.
    statement in your Code...
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

    Re: Run Macro, but switch into "F8" mode while it's running?

    You can use breakpoints (F9) in the code to interrupt execution.
    If posting code please use code tags, see here.

+ 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. [SOLVED] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2017, 06:11 AM
  2. How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro
    By andrewyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 12:47 AM
  3. Excel 2007 : make "text" like "mode" fuction
    By Side.Order in forum Excel General
    Replies: 2
    Last Post: 10-22-2010, 04:31 AM
  4. Replies: 1
    Last Post: 02-07-2010, 12:44 AM
  5. Make "Edit" mode default, rather than "Enter"?
    By Greg Boettcher in forum Excel General
    Replies: 1
    Last Post: 07-26-2006, 08:50 PM

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