Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

notes with multiple lines in code...apostrophe workaround

Posted on 2012-03-23
4
Medium Priority
?
238 Views
Last Modified: 2012-03-23
at present I add an apostrophe at the beginning of each line in my code when making notes. Sometimes the notes are lengthy and it's a pain to add them each time.

Is there an easier way to do this?
0
Comment
Question by:Shawn
  • 2
4 Comments
 
LVL 29

Expert Comment

by:Paul Jackson
ID: 37758167
Unfortunately not, vba does not support a multiline comment character.
0
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 2000 total points
ID: 37758186
However you could write out the comment across multiple lines and then select all the lines and use the comment button on the edit icon bar with code builder to add the ' to the lines all at once.
0
 
LVL 58
ID: 37758198
If you don't add a quote, it's going to try and syntax check it (unless you turn it off, which is not good for the code you do write), and that's really annoying.  Much more so then have to type a single character IMHO.

Jim.
0
 
LVL 1

Author Closing Comment

by:Shawn
ID: 37758212
exactly what I was looking for but couldn't find it. thank you
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question