Displaying Line #'s

[jutlaux]

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.

 

[BigJimmer]

MZTools (www.mztools.com) will do what you need.

 

[jutlaux]

I used that to add the line #'s to the code, but is there a way to use those
numbers in a msgbox.

 

[BigJimmer]

It's stored in Erl

msgbox("Error " Err.Number & " in line " & Erl)