Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying text from comments to cells with line feed
I am having trouble finding a way of getting text from comments into a
cell, or even a text box, while preserving the line feeds. Ideally this would be a UDF, but all of the example ones I can find that do what I need do not handle line feeds. Any help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying text from comments to cells with line feed
This works if you turn on text wrapping in the cell: Function comment2cell(rTarget As Range) As String comment2cell = rTarget.Comment.Text End Function Note that if rTarget doesn't have a comment or is 1 cell this return #VALUE. Co -- colofnatur ----------------------------------------------------------------------- colofnature's Profile: http://www.excelforum.com/member.php...fo&userid=3435 View this thread: http://www.excelforum.com/showthread.php?threadid=55939 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
How can I insert a line feed in the text in an EXCEL cell? | Excel Discussion (Misc queries) | |||
How to do a line feed in a Text Box | Excel Programming | |||
How do I get rid of line feed characters in wrapped text? | Excel Discussion (Misc queries) | |||
how does excel store new line and line feed characters? | Excel Programming |