Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi, just wanted to clarify that there is no easy way to state the line number that caused an error in a messagebox when producing a custom error handler. Had a look at some other posts and they suggest erl, is this the best approach, thanks -- cereldine ------------------------------------------------------------------------ cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069 View this thread: http://www.excelforum.com/showthread...hreadid=550305 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I think that is the only approach and works very well, except it makes your
code look a bit messy. Shame this can't be done without putting the numbers in. RBS "cereldine" wrote in message ... Hi, just wanted to clarify that there is no easy way to state the line number that caused an error in a messagebox when producing a custom error handler. Had a look at some other posts and they suggest erl, is this the best approach, thanks -- cereldine ------------------------------------------------------------------------ cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069 View this thread: http://www.excelforum.com/showthread...hreadid=550305 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error handler | Excel Discussion (Misc queries) | |||
Error Handler | Excel Discussion (Misc queries) | |||
Form Err.Raise error not trapped by entry procedure error handler | Excel Programming | |||
Error Handler | Excel Programming | |||
error handler | Excel Programming |