VBA line numbers

[Guest]

This is a suggestion for Microsoft:

It should be possible to automatically number and re-number lines of VBA
code, to make it easier to match code with a listing.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/communitie...4e1ca24&dg=microsoft.public.excel.programming

 

[Dave Peterson]

Maybe you can work around it...

If you copy your code to MSWord, you can do this within MSWord:
File|Page setup|Layout Tab|Line numbers button.

You may want to change to landscape and use a smaller font, too.

 

[Dave Peterson]

Or you may want to invest in PrettyCode

http://submain.com/
http://submain.com/?nav=products.pcp

 

[Guest]

Thanks, I'll check it out.

Maybe you can work around it...

If you copy your code to MSWord, you can do this within MSWord:
File|Page setup|Layout Tab|Line numbers button.

You may want to change to landscape and use a smaller font, too.

 

[Guest]

Thanks, but I'm only going to be here another month.

 

[Guest]

I was looking at the Word line numbers, and it justs prints line numbers.
That wouldn't help me find the corresponding line when I'm working in the VBA
editor. I could write something that would add a comment followed by a line
number to the end of each line, but it doesn't seem worth it right now,
because this job ends at the end of the month.

 

[Dave Peterson]

Maybe VZTools:
http://www.mztools.com/v3/features.htm

 

[Guest]

Thanks, I'm saving this suggestion. If I continue working in jobs where I'm
using VBA, these tools would be good to have.

 

[Dave Peterson]

There was a numbering option in that toolset, too.

Thanks, I'm saving this suggestion. If I continue working in jobs where I'm
using VBA, these tools would be good to have.