+ Reply to Thread
Results 1 to 6 of 6

how to auto add code line number in VBA Editor

  1. #1
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    how to auto add code line number in VBA Editor

    Hello,

    i want auto serial number of each line which i write in VBA Editor.
    is it possible??
    i have checked all the setting in Tools of VBA Editor but not getting.
    i am using Excel 2010 version, Please suggest.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: how to auto add code line number in VBA Editor

    How about trying to explaining your question so that we all understand?
    serial number ?
    Good one one, line numbers?
    Please show it in a text box of something
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: how to auto add code line number in VBA Editor

    Hi
    thanks for reply
    for example:

    Please Login or Register  to view this content.
    i have seen this many post that extreme left of vba editor (where we write the code)
    this number is auto generated while we scripting something in editor.

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: how to auto add code line number in VBA Editor

    It is not possible in the vba editor, you can see them but that's all.
    If you use an Editor line Notepad++ the numbering is shown in the left editor's border, bur the numbering cannot be placed in the editor window since it cannot be separated from the actual code.
    The posts you see where the numbers are showing are probably copied to word and there you have the option to show line numbers but that's a different story.

    and to correct you code, the empty line is a line too.

    Please Login or Register  to view this content.
    Attached Images Attached Images

  5. #5
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: how to auto add code line number in VBA Editor

    yes exactly
    i want that blur numbering which shown in the left editor's border.
    how to make visible of this number in editor?

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: how to auto add code line number in VBA Editor

    You should read my answer. THE FIRST LINE!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to display line numbers in editor?
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2016, 07:04 PM
  2. [SOLVED] Line item auto number
    By alfgrey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-30-2014, 02:36 PM
  3. [SOLVED] Line item auto number
    By alfgrey in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-30-2014, 11:17 AM
  4. Line Nos. in Visual Basic Editor
    By apka in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-12-2012, 05:43 PM
  5. replace : with new line in VBA editor
    By pike in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-15-2011, 06:23 AM
  6. [SOLVED] QUERY: auto clean VB code editor?
    By KevinGPO in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2005, 07:15 AM
  7. Horizontal black line in VB editor
    By Hari Prasadh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2005, 10:05 AM

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