show VBA source line numbers

[Markus Scheible]

Hi all,

does somebody know how I could get shown the source code
line numbers at the VBA editor? I can see the current line
where the cursor is but I would need every line numbered...

Thanks in advance and have a nice day!

Best regards

Markus

 

[keepITcool]

Markus

Download MZTools for VBA 3.0 from Quintero. A must have!
http://www.mztools.com/download/mztoolsvba.zip

Among MANY other options it does have the option
to set and remove linenumbering.

It's free, but I'm sure Carlos will appreciate
"incomings" on his PayPal account.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Markus Scheible wrote :

 

[Markus Scheible]

Hi unknown,

thanks for the tip, I already got the info about this
tool... unfortunately it is not allowed to install other
software at our computers - so is there no possibility to
get the line numbers without any extra tool?

TIA

Markus

 

[keepITcool]

Markus,
i'm not that unknown here.. i go by the name keepITcool <g>

administrators... wont allow anything on user machines while at the
same time THEY run eDonkey on their own machines....

maybe it's not allowed.. but have they blocked it? The 'only' thing you
need to install MZtools is to be able to use regsvr32 to register the
DLL.


As an alternative you need to write /find a procedure for the line
numbering. Among the tons of tools I managed to unearth 1 code snippet
from Google...

From Bernie Deitrick (no less!):
http://xlbysteph.free.fr/aideinformatique/news/vbanumeroterlignes.txt

Are you allowed access to VBObject model?
Check Macro/Security/Trusted Sources there's a checkbox at the bottom.


hth...


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Markus Scheible wrote :

 

[keepITcool]

Markus,
I've just had a look at the code from that link,..
but it's ratherr basic and probably not what you want.

Be VERY carefull running it...

I may attempt something of my own. I'll post back when I've something
worthwhile.





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


keepITcool wrote :

 

[Tom Ogilvy]

Here is the entire thread from that exchange. There may be more to "mine"
there:

http://groups.google.co.uk/groups?hl=en&lr=&[email protected]

 

[keepITcool]

Tom,

thanks for that thread. Stephen Bullen's contribution there looks like
what I was in the process of building. (Process aborted now)

I do have MZtools anyway, but it looks to me as a logical xtra for
Stephen's smart indenter?


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Tom Ogilvy wrote :

 

[arno]

thanks for the tip, I already got the info about this

tool

Na toll. Jetzt wirf ihm vielleich noch vor, er hätte dein Crossprosting
gefälligst lesen sollen!



arno