Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Line #'s
I would like to add line numbers through out my VB code and then when I get
errors be able to display what line # caused the problem with a msgbox. The problem I have is that I can not remember the format for the line # or the code to display them. For some reason I thought there was predefined structure to do this, but maybe I'm way off target here. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Line #'s
MZTools (www.mztools.com) will do what you need.
"jutlaux" wrote: I would like to add line numbers through out my VB code and then when I get errors be able to display what line # caused the problem with a msgbox. The problem I have is that I can not remember the format for the line # or the code to display them. For some reason I thought there was predefined structure to do this, but maybe I'm way off target here. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Line #'s
I used that to add the line #'s to the code, but is there a way to use those
numbers in a msgbox. "BigJimmer" wrote: MZTools (www.mztools.com) will do what you need. "jutlaux" wrote: I would like to add line numbers through out my VB code and then when I get errors be able to display what line # caused the problem with a msgbox. The problem I have is that I can not remember the format for the line # or the code to display them. For some reason I thought there was predefined structure to do this, but maybe I'm way off target here. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Line #'s
It's stored in Erl
msgbox("Error " Err.Number & " in line " & Erl) "jutlaux" wrote: I used that to add the line #'s to the code, but is there a way to use those numbers in a msgbox. "BigJimmer" wrote: MZTools (www.mztools.com) will do what you need. "jutlaux" wrote: I would like to add line numbers through out my VB code and then when I get errors be able to display what line # caused the problem with a msgbox. The problem I have is that I can not remember the format for the line # or the code to display them. For some reason I thought there was predefined structure to do this, but maybe I'm way off target here. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying a horizontal quota line on a graph | Charts and Charting in Excel | |||
Hard line break displaying as rectangle on import from SQL | Excel Programming | |||
Displaying data in bar form on a line chart | Charts and Charting in Excel | |||
chart displaying horizontal line for zero data | New Users to Excel | |||
when displaying formulas, how to start a new line in the same cel. | Excel Discussion (Misc queries) |