title: Set breakpoint in VBA code programmatically
body: <p>I have a very large piece of code written in VBA (>50,000 lines - numerous modules). There is one array of interest to me, and I'd like to find all the conditions under which the value of any element of this array changes. The values can change in any module. Running the script line by line is not the most efficient option due to the size of the code.  </p>
  
  <p>I am looking for better ways to solve this problem. Two ways that come to my mind is to programmatically set a breakpoint (which I am not sure if can be done) or programmatically insert an if-block after each assignment that somehow alerts me that the value has changed. (not preferred). </p>
  
  <p>So my question boils down to:</p>
  
  <ol>
  <li>Is it possible to programmatically set breakpoints in VBA code?</li>
  <li>If the answer to the above question is <strong>No</strong>, what is an efficient way to solve this problem?</li>
  </ol>
  
  <p><strong>UPDATE:</strong>
  Thanks for the comments/replies. As I had implied, I am interested in the least amount of modification to the current code (i.e. inserting if-blocks, etc) and most interested in the break-point idea. I'd like to know if it's doable.</p>