Results 1 to 5 of 5

Any way to list breakpoints?

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    11-15-2010
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2003
    Posts
    538

    Any way to list breakpoints?

    I hate "clear all breakpoints." I wish I could just "go to next breakpoint" and decide whether to keep or lose it. Also sometimes I'll set 15 of them so I can check 15 code changes, and after I've done about 13 or 14 of them, I'd like to know if there are more remaining. If I can list them somehow, awesome; and if there's an object I can get to in code, I can take it from there. Can I list them through an existing interface? Or is there an object?

    But my first preference is just to list the "red F9 breakpoints" without any coding required. Failing that, is there an object?

    AND. BELOW IS NOT PART OF THE QUESTION, BUT IF YOU CAN SPEAK SPECIFICALLY TO THIS, GREAT. If they are in an accessible object, and it's not read only, I might in personal.xls have something like this. Is something like this on the table?
    sub EncodeBP(sStr as string)
    D_Object.AddBreakPoint(sStr)
    D_Object.BreakPoints(sStr).type=xlBreakWhenChanged
    End sub
    Last edited by Oppressed1; 03-15-2016 at 04:30 PM. Reason: Cut out lots of discussion and code contemplating using debug.Assert instead of traditional breakpoints.
    Chip, if you can read this, you're STILL making the world a better place with your immeasurably valuable gifts. Every week, you continue to help me (and untold numbers of others) tremendously. Practically no alternative outlets can match your effectiveness, even over the vast number of topics you demystify and empower usage of. You were, and still are, amazing.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Phantom Breakpoints or whatever you might call them ....
    By fred3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-29-2014, 07:06 PM
  2. Phantom Breakpoints Driving me insane!
    By fred3 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-04-2014, 01:36 PM
  3. Replies: 3
    Last Post: 04-22-2014, 03:30 PM
  4. My Userform don't stop with breakpoints.
    By Francisco Sousa in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-16-2013, 06:53 PM
  5. Having a problem stepping through VBA and setting breakpoints at same time
    By JoeyBee in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-16-2013, 10:43 AM
  6. Not hitting breakpoints!...
    By cmyers65 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-14-2011, 08:13 PM
  7. Breakpoints Ignored
    By Lord Fitzy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-02-2007, 07:49 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