| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert a hyperlink in text in a paragraph | Excel Discussion (Misc queries) | |||
| insert a paragraph break within text in a singel cell? | Excel Discussion (Misc queries) | |||
| Search for lowercase followed by uppercase and insert paragraph | Excel Discussion (Misc queries) | |||
| How to insert from name range into a paragraph? | Excel Worksheet Functions | |||
| How do I insert a comment when the Insert:Comment menu is greyed? | Excel Discussion (Misc queries) | |||
Linear Mode
