Stepping thru code

[Giordano Bruno]

I have a workbook which contains the Function IsEmailValid(strEmail) It does its job perfectly well, but when I step though other code modules and change the worksheets in any way, this function suddenly gets called and I have to step through it to resume where the code suddenly jumped out. I have code that activates on workbook changes, but this is never called so this is not the cause. It happens intermittently, but quite frequently. It never happens when I run the code normally and none of my other functions ever gets these phantom calls. If anyone has any suggestions, I'd be most grateful.

 

[shknbk2]

Do you know if any of the cells on the worksheet call this function? Would that cell call get triggered if the worksheet changes due to automatic calculation?

 

[Giordano Bruno]

Hi shknbk2. Thanks for the reply. The code is normally called only when a button is clicked to send the file as an email attachment. One of the checks this code makes is to call the function to determine whether the cell with the email address looks like a real address. This is the only path that leads to this function and no other code refers to this cell.

 

[shknbk2]

Does anything change for the better if you make the function Private?

 

[JoeMo]

I have a workbook which contains the Function IsEmailValid(strEmail) It does its job perfectly well, but when I step though other code modules and change the worksheets in any way, this function suddenly gets called and I have to step through it to resume where the code suddenly jumped out. I have code that activates on workbook changes, but this is never called so this is not the cause. It happens intermittently, but quite frequently. It never happens when I run the code normally and none of my other functions ever gets these phantom calls. If anyone has any suggestions, I'd be most grateful.

Don't know that you can avoid that, but you don't have to step through the function that's called inadvertently. Instead, hold down ctrl and shift keys and hit F8 to get back to the code of interest where the jump occurred.

 

[Giordano Bruno]

Hi shknbk2, I'll give it a try. Anything to stop this annoying behaviour.
Thanks for your interest JoeMO. I didn't know about that trick; sounds very useful. By the way, do you know if this is a VBA bug or have I been singled out for special treatment?

 

[JoeMo]

Thanks for your interest JoeMO. I didn't know about that trick; sounds very useful. By the way, do you know if this is a VBA bug or have I been singled out for special treatment?

Don't know if its a bug, but I experience it frequently.

 

[Giordano Bruno]

Hi shknbk2. Your suggestion was worth a try, but I can now say that it definitely does not work. Pity!
Hi JoeMo. If it affects two people it's either a "feature" or a "bug". Since it has only nuisance value I think you can rule out that it's a feature.