Sheet direction, extract data from comment
 

I would like to change the sheet direction by default.
Also if it is possible, how to extract data from comment to cell.

--
MFS22

Sheet direction, extract data from comment
 

You can try the below UDF. To try this launch VBE using Alt+F11. Insert
module and paste the below code. Save and close VBE. Get back to workbook.

Sub GetComment(varData)
GetComment = varData.Comment.Text
End Sub


Add a comment to cell A1
B1 = GetComment(A1)

If this post helps click Yes
---------------
Jacob Skaria


"MFS" wrote:

I would like to change the sheet direction by default.
Also if it is possible, how to extract data from comment to cell.

--
MFS22

Sheet direction, extract data from comment
 

Revised...

Function GetComment(varRange As Range) As String
For Each c In varRange
If Not c.Comment Is Nothing Then
GetComment = GetComment & c.Comment.Text & ","
End If
Next
End Function

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

You can try the below UDF. To try this launch VBE using Alt+F11. Insert
module and paste the below code. Save and close VBE. Get back to workbook.

Sub GetComment(varData)
GetComment = varData.Comment.Text
End Sub


Add a comment to cell A1
B1 = GetComment(A1)

If this post helps click Yes
---------------
Jacob Skaria


"MFS" wrote:

I would like to change the sheet direction by default.
Also if it is possible, how to extract data from comment to cell.

--
MFS22

Sheet direction, extract data from comment
 

Hi,
You may want to refer to question 46 of the following link -
http://ashishmathur.com/replies.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"MFS" wrote in message
...
I would like to change the sheet direction by default.
Also if it is possible, how to extract data from comment to cell.

--
MFS22