ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to see how many lines of code ? (https://www.excelbanter.com/excel-programming/351338-how-see-how-many-lines-code.html)

SpookiePower

How to see how many lines of code ?
 
Is it possible to se how many lines of code that I have written
in design mode ?

--
Mit fotoalbum
www.photo.activewebsite.dk



Norman Jones

How to see how many lines of code ?
 
Hi SpookiePower,

Try something like:

MsgBox Application.VBE.ActiveVBProject. _
VBComponents("Module1").CodeModule.CountOfLines


---
Regards,
Norman


"SpookiePower" wrote in message
. dk...
Is it possible to se how many lines of code that I have written
in design mode ?

--
Mit fotoalbum
www.photo.activewebsite.dk




SpookiePower

How to see how many lines of code ?
 
Thanks


NickHK

How to see how many lines of code ?
 
SpookiePower,
MZ Tools have a good add-in that gives you various stats and adds a variety
of other enhancements.
http://www.mztools.com/

NickHK

"SpookiePower" wrote in message
. dk...
Is it possible to se how many lines of code that I have written
in design mode ?

--
Mit fotoalbum
www.photo.activewebsite.dk






All times are GMT +1. The time now is 10:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com