Displaying Line #'s

's Computer Specifications

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.

's Computer Specifications

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.
>
>
>

's Computer Specifications

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.
> >
> >
> >

's Computer Specifications

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.
> > >
> > >
> > >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Displaying Tasks on more than one line	Nick W	Microsoft Outlook Discussion	0	27th May 2009 12:51 PM
displaying a line graph	ravindar thati	Microsoft Access Form Coding	1	22nd Apr 2007 05:04 AM
Displaying results on one line	=?Utf-8?B?cGhhbmRh?=	Microsoft Access Reports	2	26th May 2006 01:11 AM
Stop displaying a line	=?Utf-8?B?SmVyZXpfeg==?=	Microsoft Excel Misc	1	7th Jul 2004 12:45 PM
manually displaying on the next line	Albert Byun	Microsoft Excel Discussion	1	3rd Jun 2004 09:52 PM