Break mode reset project problem

[Stoffel24]

Hi all

I find that when in break mode (excel), sometimes when I wish to edit a line, a message box appears telling me "This will Reset your project. Reset anyway?". Sometimes when I click on cancel and then try again it works and other times I need to move my next point of execution up a few lines to get it to work. Sometimes what worked before now doesn't seem to anymore. (ie Say I am in a piece of code that is called repeatedly. On the same line of code, I used to be able to edit the code and now am not one call later or I used to move the point of execution up 2 lines and this got it working and now that doesn't work anymore.) It is all a mystery to me as to why it does this. Any light to be shed? [Idea]

 

[Nikita6003]

Hiya,

well, this has happened to me a LOT. Usually, editing code = fine in break mode (tho' beware - could lead to corruption in code - we've had many Dr Watson's in our Citrix environment while editing code in break mode. We've stopped doing this to out 'live' tools ;-))

Why does it do this? Here's a few instances:
1. Changing a variable declaration. During debug that's a nono. You can however add new Dim statements to your heart's content.
2. Redim and Redim Preserve statements. VBE will not allow you to change these (not even to add an indent or move it down a few lines.
3. Adding/Removing parameters from Subs and Functions
4. Adding a Case to a Select Case or changing an existing Case. You *can* change code within your Case statement.
5. If .. Then .. Else - you can't change if the breakpoint's on the bit of the If .. Then .. Else you're trying to edit. Move the breakpoint up one line & away ypou go - you've now got an editable If .. Then .. Else

...

there's more, but this'll give you an indication ;-)

Cheers
Nikki