| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Line and row numbers | New Users to Excel | |||
| Line numbers some numbers are blue some are black | Excel Discussion (Misc queries) | |||
| VBA - Line Numbers ? | Excel Programming | |||
| Line numbers | Excel Programming | |||
| Line numbers | Excel Programming | |||
Linear Mode
