"Comment out" besides ' ?

[StargateFan]

In a scripting language I use, we can comment out individual lines,
too with a "comment out"-symbol similar to Excel (where in Excel we
use the apostrophe [']).

The difference is that this code coments out whole blocks of text.
By putting in #cs for when the comment starts, then #ce for when it
ends, it's a way to put in a large piece of text that's not code.

i.e., :


#cs
a large blurb of text goes here that explains something that isn't
code. But by putting in the #cs above and #ce below, we don't have to
manually comment-out each individual line. The text inside isn't code
and doesn't get executed, etc.
#ce

Does Excel have anything like that? I've never seen it in all my
travels <g>.

Thanks. D

 

[Frederik]

There is a button in the toolbar Edit to mark a portion of code as text.
Success!

 

[Dave Peterson]

Not that I've seen.

But there are icons on the Edit toolbar
View|toolbars|Edit
(in the VBE)

That allow you to comment and uncomment blocks of code.

In a scripting language I use, we can comment out individual lines,
too with a "comment out"-symbol similar to Excel (where in Excel we
use the apostrophe [']).

The difference is that this code coments out whole blocks of text.
By putting in #cs for when the comment starts, then #ce for when it
ends, it's a way to put in a large piece of text that's not code.

i.e., :

#cs
a large blurb of text goes here that explains something that isn't
code. But by putting in the #cs above and #ce below, we don't have to
manually comment-out each individual line. The text inside isn't code
and doesn't get executed, etc.
#ce

Does Excel have anything like that? I've never seen it in all my
travels <g>.

Thanks. D

 

[StargateFan]

Not that I've seen.

But there are icons on the Edit toolbar
View|toolbars|Edit
(in the VBE)

Perfect! I see that in every new place I go to, I'll have to show
that EDIT toolbar!

Sure enough, I selected text then on that toolbar chose the button
with tooltip "comment block" and it added a ' to the beginning of each
line that I had highlighted.

Good enough! As long as I no longer have to manually put a ' at the
beginning of each "comment out" portion of code, I can live with that.

Then when you need to make that code live again, you re-select the
same portion and click on "Uncomment Block".

Commenting out is what I've been using in the scripting language to
isolate bits of code. This will, in essence, do the same type of
thing.

Thanks. D

That allow you to comment and uncomment blocks of code.

In a scripting language I use, we can comment out individual lines,
too with a "comment out"-symbol similar to Excel (where in Excel we
use the apostrophe [']).

The difference is that this code coments out whole blocks of text.
By putting in #cs for when the comment starts, then #ce for when it
ends, it's a way to put in a large piece of text that's not code.

i.e., :

#cs
a large blurb of text goes here that explains something that isn't
code. But by putting in the #cs above and #ce below, we don't have to
manually comment-out each individual line. The text inside isn't code
and doesn't get executed, etc.
#ce

Does Excel have anything like that? I've never seen it in all my
travels <g>.

Thanks. D