Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |