How do I insert a preformated paragraph into a comment?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I would like to insert a standardized paragraph into a comment.
The text would be something like:
"Work: (actions)
Part: (materials)
Data: (information used in calculations)"

Consider the following code:
If ct Is Nothing Then
ActiveCell.AddComment
Set ct = ActiveCell.Comment
'text
ct.Text "Work: (actions){enter}Part: (materials){enter}Data:
(information used in calculations)"
End If

Obviously {enter} is not working to add the carriage return that I am
looking for.

Thanks!
Mark
 
"Text1" & variableText & vbcrlf & ......

"Text1" & variableText & chr(10) & ......
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

code to make a comment macro uneditable 4
Code to add comments to selected cells within a selected range 30
Aligning comments 3
Summary table for cell comments (updatable) 2
What are the character codes of a carriage return entered in a comment? 5
Font and Paragraph formatting in comment 1
How do I insert a row (space) between bulleted (#) paragraphs? 3
Macro to Insert Comment to a cell 18

Back
Top