VBA Stop Points

[Wyvern]

Hi, I'm (somewhat sheepishly) experiencing different behaviour from Excel depending on whether I have a stop point set in my macro or not. If I have a stop point it works, if I don't it doesn't.

I suspect it's just me being daft... here is a subsection of code...

Please Login or Register  to view this content.

If I place a stop point (say on the application.calculate row) in the above code and change the drop list KPI, and simply continue when it hits the stop point it refreshes the screen (picture 1) (note how the drop box at the top says "earned premium" as does the graph heading). If I do the same thing and have no stop point it doesn't (picture 2) (note how the drop box says "gross new bus prem" and the graph still says "earned units").

I know I'm not giving a lot of info here, but I suspect it's one of those problems where the answer is obvious to those who know. Plus the code associated with this small application is significant.

Many thanks for any help that can be offered.

[pike]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here