ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro-insert text(personal comment) (https://www.excelbanter.com/excel-discussion-misc-queries/243667-macro-insert-text-personal-comment.html)

puiuluipui

Macro-insert text(personal comment)
 
Hi, is there anyway i can insert personal text(ideas) in a macro?
Ex:
.......Here begins date macro.............
MACRO
.......Here it ends..................

.......Here begins copy/paste macro......
MACRO
.......Here it ends.........

Can this be done?
Thanks!

Sean Timmons

Macro-insert text(personal comment)
 
Use a single quote before your comment

'Here begins date macro

It will show in Green

you must enter the single quote on each line of code that has a comment.

"puiuluipui" wrote:

Hi, is there anyway i can insert personal text(ideas) in a macro?
Ex:
......Here begins date macro.............
MACRO
......Here it ends..................

......Here begins copy/paste macro......
MACRO
......Here it ends.........

Can this be done?
Thanks!


puiuluipui

Macro-insert text(personal comment)
 
Works perfect!
Thanks!

"Sean Timmons" wrote:

Use a single quote before your comment

'Here begins date macro

It will show in Green

you must enter the single quote on each line of code that has a comment.

"puiuluipui" wrote:

Hi, is there anyway i can insert personal text(ideas) in a macro?
Ex:
......Here begins date macro.............
MACRO
......Here it ends..................

......Here begins copy/paste macro......
MACRO
......Here it ends.........

Can this be done?
Thanks!



All times are GMT +1. The time now is 09:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com