VBA line numbers
 

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/communities...el.programming

VBA line numbers
 

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.

Patricia Shannon wrote:

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/communities...el.programming

--

Dave Peterson

VBA line numbers
 

Or you may want to invest in PrettyCode

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


Patricia Shannon wrote:

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/communities...el.programming

--

Dave Peterson

VBA line numbers
 

Thanks, I'll check it out.

"Dave Peterson" wrote:

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.

Patricia Shannon wrote:

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/communities...el.programming

--

Dave Peterson

VBA line numbers
 

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

"Dave Peterson" wrote:

Or you may want to invest in PrettyCode

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


Patricia Shannon wrote:

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/communities...el.programming

--

Dave Peterson

VBA line numbers
 

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" wrote:

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.

Patricia Shannon wrote:

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/communities...el.programming

--

Dave Peterson

VBA line numbers
 

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



Patricia Shannon wrote:

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

"Dave Peterson" wrote:

Or you may want to invest in PrettyCode

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


Patricia Shannon wrote:

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/communities...el.programming

--

Dave Peterson


--

Dave Peterson

VBA line numbers
 

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" wrote:

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



Patricia Shannon wrote:

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

"Dave Peterson" wrote:

Or you may want to invest in PrettyCode

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


Patricia Shannon wrote:

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/communities...el.programming

--

Dave Peterson


--

Dave Peterson

VBA line numbers
 

There was a numbering option in that toolset, too.

Patricia Shannon wrote:

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" wrote:

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



Patricia Shannon wrote:

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

"Dave Peterson" wrote:

Or you may want to invest in PrettyCode

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


Patricia Shannon wrote:

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/communities...el.programming

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson