• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

notes with multiple lines in code...apostrophe workaround

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
Shawn
Asked:
Shawn
  • 2
1 Solution
 
Paul JacksonSoftware EngineerCommented:
Unfortunately not, vba does not support a multiline comment character.
0
 
Paul JacksonSoftware EngineerCommented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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
 
ShawnAuthor Commented:
exactly what I was looking for but couldn't find it. thank you
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now