How do I insert a preformated paragraph into a comment?
 

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

How do I insert a preformated paragraph into a comment?
 

"Text1" & variableText & vbcrlf & ......

"Text1" & variableText & chr(10) & ......

--
steveB

Remove "AYN" from email to respond
"Mark" wrote in message
...
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