Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: Error handling
I have created a function that returns a string. When it fails, Excel
reports "#VALUE!". I would like to report my description of the error instead. I have tried to use error handling, but it seems to be ignored. In the area in which I "Try to do some useful Stuff", an error occasionally occurs. The debugger shows that control does not transfer to my ErrorHandler. Instead, execution ends immediately, and the cell value is set to "#VALUE!". Public Function myFunction() As String On Error GoTo ErrorHandler ' Try to do some useful Stuff myFunction = "RESULT" FunctionExit: Exit Function ErrorHandler: Err.Clear myFunction = "My Error Description" Resume FunctionExit End Function Thanks for your assistance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Handling | Excel Discussion (Misc queries) | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
Error Handling | Excel Programming | |||
Error handling with a handling routine | Excel Programming | |||
Error handling | Excel Programming |