+ Reply to Thread
Results 1 to 6 of 6

VBA - Line Numbers ?

  1. #1
    Forum Contributor
    Join Date
    12-22-2004
    Location
    Kokomo, Indiana
    Posts
    236

    Question VBA - Line Numbers ?

    Group,
    Is it possible to have line numbers in a VBA project? If so, how do I do it? I'm running Excel 2002.

    Tony

  2. #2
    Norman Jones
    Guest

    Re: VBA - Line Numbers ?

    Hi Tony,

    See the free MZTools addin which may be downloaded at:

    http://www.mztools.com/

    The addin includes many other VBA tools.

    ---
    Regards,
    Norman



    "ajocius" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Group,
    > Is it possible to have line numbers in a VBA project? If so, how do
    > I do it? I'm running Excel 2002.
    >
    > Tony
    >
    >
    > --
    > ajocius
    > ------------------------------------------------------------------------
    > ajocius's Profile:
    > http://www.excelforum.com/member.php...o&userid=17695
    > View this thread: http://www.excelforum.com/showthread...hreadid=470567
    >




  3. #3
    Vacation's Over
    Guest

    RE: VBA - Line Numbers ?

    i agree with Norman, Don't know how anyone can code VBA without MZ Tools,
    might also try "Smart indenter" way cool for poor typing and clean code.
    www.OALTD.CO.UK

    also a free download

    "ajocius" wrote:

    >
    > Group,
    > Is it possible to have line numbers in a VBA project? If so, how do
    > I do it? I'm running Excel 2002.
    >
    > Tony
    >
    >
    > --
    > ajocius
    > ------------------------------------------------------------------------
    > ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
    > View this thread: http://www.excelforum.com/showthread...hreadid=470567
    >
    >


  4. #4
    Forum Contributor
    Join Date
    02-26-2005
    Posts
    175
    Hi Norman,
    You know my expertise level, Would you recomend this for me to use, or is it over my head?
    Dave
    Quote Originally Posted by Norman Jones
    Hi Tony,

    See the free MZTools addin which may be downloaded at:

    http://www.mztools.com/

    The addin includes many other VBA tools.

    ---
    Regards,
    Norman



    "ajocius" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Group,
    > Is it possible to have line numbers in a VBA project? If so, how do
    > I do it? I'm running Excel 2002.
    >
    > Tony
    >
    >
    > --
    > ajocius
    > ------------------------------------------------------------------------
    > ajocius's Profile:
    > http://www.excelforum.com/member.php...o&userid=17695
    > View this thread: http://www.excelforum.com/showthread...hreadid=470567
    >

  5. #5
    Norman Jones
    Guest

    Re: VBA - Line Numbers ?

    Hi Dave,

    The MZTools addin comprises many potentially useful tools. It will not
    programme for you, but it may facilitate such programming. In my opinion,
    some of these tools could profitably be used by anyone with more than an a
    casual acquaintance with VB(A) programming.

    In this connection, you may be interested in Chip Pearsons's assessment at:

    http://www.cpearson.com/excel/xltools.htm
    ========================================
    MZTools by Carlos Quintero
    This is one of the best add-ins for the Visual Basic Editor ever written.
    It provides hundreds of tools to make coding easier.
    ========================================


    ---
    Regards,
    Norman



    "Piranha" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Hi Norman,
    > You know my expertise level, Would you recomend this for me to use, or
    > is it over my head?
    > Dave
    > Norman Jones Wrote:
    >> Hi Tony,
    >>
    >> See the free MZTools addin which may be downloaded at:
    >>
    >> http://www.mztools.com/
    >>
    >> The addin includes many other VBA tools.
    >>
    >> ---
    >> Regards,
    >> Norman
    >>
    >>
    >>
    >> "ajocius" <[email protected]> wrote
    >> in
    >> message news:[email protected]...
    >> >
    >> > Group,
    >> > Is it possible to have line numbers in a VBA project? If so, how do
    >> > I do it? I'm running Excel 2002.
    >> >
    >> > Tony
    >> >
    >> >
    >> > --
    >> > ajocius
    >> >

    >> ------------------------------------------------------------------------
    >> > ajocius's Profile:
    >> > http://www.excelforum.com/member.php...o&userid=17695
    >> > View this thread:

    >> http://www.excelforum.com/showthread...hreadid=470567
    >> >

    >
    >
    > --
    > Piranha
    > ------------------------------------------------------------------------
    > Piranha's Profile:
    > http://www.excelforum.com/member.php...o&userid=20435
    > View this thread: http://www.excelforum.com/showthread...hreadid=470567
    >




  6. #6
    Forum Contributor
    Join Date
    02-26-2005
    Posts
    175
    Hi Norman,

    Well i have "more than an a casual acquaintance with VB(A)" That dosen't mean however,
    that i know what i am doing.
    Will give it a try.

    Thx
    Dave
    Quote Originally Posted by Norman Jones
    Hi Dave,

    The MZTools addin comprises many potentially useful tools. It will not
    programme for you, but it may facilitate such programming. In my opinion,
    some of these tools could profitably be used by anyone with more than an a
    casual acquaintance with VB(A) programming.

    In this connection, you may be interested in Chip Pearsons's assessment at:

    http://www.cpearson.com/excel/xltools.htm
    ========================================
    MZTools by Carlos Quintero
    This is one of the best add-ins for the Visual Basic Editor ever written.
    It provides hundreds of tools to make coding easier.
    ========================================


    ---
    Regards,
    Norman



    "Piranha" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Hi Norman,
    > You know my expertise level, Would you recomend this for me to use, or
    > is it over my head?
    > Dave
    > Norman Jones Wrote:
    >> Hi Tony,
    >>
    >> See the free MZTools addin which may be downloaded at:
    >>
    >> http://www.mztools.com/
    >>
    >> The addin includes many other VBA tools.
    >>
    >> ---
    >> Regards,
    >> Norman
    >>
    >>
    >>
    >> "ajocius" <[email protected]> wrote
    >> in
    >> message news:[email protected]...
    >> >
    >> > Group,
    >> > Is it possible to have line numbers in a VBA project? If so, how do
    >> > I do it? I'm running Excel 2002.
    >> >
    >> > Tony
    >> >
    >> >
    >> > --
    >> > ajocius
    >> >

    >> ------------------------------------------------------------------------
    >> > ajocius's Profile:
    >> > http://www.excelforum.com/member.php...o&userid=17695
    >> > View this thread:

    >> http://www.excelforum.com/showthread...hreadid=470567
    >> >

    >
    >
    > --
    > Piranha
    > ------------------------------------------------------------------------
    > Piranha's Profile:
    > http://www.excelforum.com/member.php...o&userid=20435
    > View this thread: http://www.excelforum.com/showthread...hreadid=470567
    >

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1