Hi, I have a file with hundereds of card number with their corresponiding
cell with relative info. These corresponding cells have comments, I want to
put the comments in separate cell so that I can look at these in one go,
otherewise I have to put the pointer on individual cell to read the comment.
Can anyone halp me out.
Thanks,
Amit.

Saved from a previous post:

You can retrieve the text from a comment with a userdefined function like:

Option Explicit
Function GetComment(FCell As Range) As Variant
Application.Volatile

Set FCell = FCell(1)

If FCell.Comment Is Nothing Then
GetComment = ""
Else
GetComment = FCell.Comment.Text
End If

End Function

Then you can use it like any other function:

=getcomment(a1)

But be aware that the function won't evaluate when you just change the comment.
It'll be correct when excel recalculates. (Hit F9 to force a recalc.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Amit Kumar Baidyaka wrote:

Hi, I have a file with hundereds of card number with their corresponiding
cell with relative info. These corresponding cells have comments, I want to
put the comments in separate cell so that I can look at these in one go,
otherewise I have to put the pointer on individual cell to read the comment.
Can anyone halp me out.
Thanks,
Amit.

--

Dave Peterson

Hi Peter, Could u please simplify what u have written, as I could not
implement the same.Thanks, Amit.

"Dave Peterson" wrote:

Saved from a previous post:

You can retrieve the text from a comment with a userdefined function like:

Option Explicit
Function GetComment(FCell As Range) As Variant
Application.Volatile

Set FCell = FCell(1)

If FCell.Comment Is Nothing Then
GetComment = ""
Else
GetComment = FCell.Comment.Text
End If

End Function

Then you can use it like any other function:

=getcomment(a1)

But be aware that the function won't evaluate when you just change the comment.
It'll be correct when excel recalculates. (Hit F9 to force a recalc.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Amit Kumar Baidyaka wrote:

Hi, I have a file with hundereds of card number with their corresponiding
cell with relative info. These corresponding cells have comments, I want to
put the comments in separate cell so that I can look at these in one go,
otherewise I have to put the pointer on individual cell to read the comment.
Can anyone halp me out.
Thanks,
Amit.

--

Dave Peterson

After you read David McRitchie's notes, what were your specific questions.

I'm not sure I know where to start.

Short course:

Open your workbook.
Hit alt-f11 to get to the VBE (where macros/UDF's live)
hit ctrl-r to view the project explorer
Find your workbook.
should look like: VBAProject (yourfilename.xls)

right click on the project name
Insert, then Module
You should see the code window pop up on the right hand side

Paste the code in there.

Now go back to excel.
Into a test cell and type:
=getcomment(a1)


Amit Kumar Baidyaka wrote:

Hi Peter, Could u please simplify what u have written, as I could not
implement the same.Thanks, Amit.

"Dave Peterson" wrote:

Saved from a previous post:

You can retrieve the text from a comment with a userdefined function like:

Option Explicit
Function GetComment(FCell As Range) As Variant
Application.Volatile

Set FCell = FCell(1)

If FCell.Comment Is Nothing Then
GetComment = ""
Else
GetComment = FCell.Comment.Text
End If

End Function

Then you can use it like any other function:

=getcomment(a1)

But be aware that the function won't evaluate when you just change the comment.
It'll be correct when excel recalculates. (Hit F9 to force a recalc.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Amit Kumar Baidyaka wrote:

Hi, I have a file with hundereds of card number with their corresponiding
cell with relative info. These corresponding cells have comments, I want to
put the comments in separate cell so that I can look at these in one go,
otherewise I have to put the pointer on individual cell to read the comment.
Can anyone halp me out.
Thanks,
Amit.

--

Dave Peterson


--

Dave Peterson