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.
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.
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
Hi
thanks for reply
for example:
i have seen this many post that extreme left of vba editor (where we write the code)![]()
1. Dim i as Integer 2. Dim shtMain as Worksheet 3. for i= 1 to 10 4. MsgBox i 5. Next i
this number is auto generated while we scripting something in 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.
![]()
1. Dim i as Integer 2. Dim shtMain as Worksheet 3. 4. for i= 1 to 10 5. MsgBox i 6. Next i
yes exactly
i want that blur numbering which shown in the left editor's border.
how to make visible of this number in editor?
You should read my answer. THE FIRST LINE!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks