| 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) | |||
Hybrid Mode
