Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way to get the VBE module and module line, given the procedure
and erl where an error occured? The idea is to move straight to the line in the VBE where the error occured after handling the error. I have numbered the lines per procedure with MZ Tools. I can move to the line when I have the module and the module line: With ThisWorkbook.VBProject.VBComponents(strModule).Cod eModule.CodePane .SetSelection lStartLine, 1, lStartLine, 1 .Show End With I could make my error handler retain the module as well as the procedure, but even then I am not sure I could get to the module line. RBS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
to call procedure in a worksheet in a module | Excel Discussion (Misc queries) | |||
Running a procedure in a module on graph change | Excel Programming | |||
Add Procedure To Module Via VBA | Excel Programming | |||
programmatically open VBE and go to a specified procedure in target module? | Excel Programming | |||
Lines in a Module(Procedure) | Excel Programming |