View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
BigJimmer BigJimmer is offline
external usenet poster
 
Posts: 37
Default 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.