Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default How to see how many lines of code ?

Thanks

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please Explain Two Lines of Code ca1358 Excel Programming 1 January 18th 06 04:47 PM
Code to write out all lines of code davidm Excel Programming 3 August 5th 05 04:26 AM
How to combine lines of code? Papa Jonah Excel Programming 2 February 17th 05 08:23 AM
Help Please: Need code to test several lines bruce forster Excel Programming 3 April 7th 04 04:27 AM
Lines fo code Neeraja[_2_] Excel Programming 2 October 16th 03 01:07 PM


All times are GMT +1. The time now is 12:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"