| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call Procedure with On Error Statement
Is there a way to call my error handler procedure when an error occurs in any
of my procedures. This is kinda what I was looking for. Sub Test() On Error GoTo ErrorHandler(Err.Number) 'my code here End Sub Sub ErrorHandler(ByVal intErrorNumber As Integer) Select Case intErrorNumber Case 1 'do this 'and so on End Select End Sub -- Cheers, Ryan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Range variable to call a procedure with a ByVal statement... | Excel Programming | |||
| Run-time Error '5' - Invalid procedure call or argument | Excel Discussion (Misc queries) | |||
| procedure call error issue | Excel Programming | |||
| Invalid procedure call or argument error | Excel Programming | |||
| Run-time error '5':Invalid Procedure call or argument | Excel Programming | |||
Threaded Mode
