Solved

notes with multiple lines in code...apostrophe workaround

Posted on 2012-03-23
4
235 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

635 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