How to determine error raised in sub

[BigJimSlade]

Hi, Big Jim here,

I did not know how to articulate this well, so I hope it has not already been posted 1,000 times.

Suppose I was running Sub Procedure A and called Sub Procedure B. Procedure B gets an error, and my error handling causes Proc B to end and return to Proc A.

Is there an intrinsic means within VBA to show that an error was handled once I have left Proc B? (This is all because I may not want to run Proc A any further if Proc B failed.)

Thanks in advance...
Big Jim

 

[The Stoat]

High Big Jim try this


Fup is my function that i deliberatley Fup'd
I used the On error resume next in my calling procedure and then when the error occured in my function it evaluated to iserror = true and displayed the msgbox

when i correct my function it skipped over the msgbox as hoped



If IsError(Fup) Then

MsgBox "Hurrah"


End If



The Stoat

 

[BigJimSlade]

Ah, Big Jim thanks The Stoat for his wise advice.

Thanks again!

Big Jim

 

[The Stoat]

My Pleasure