• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help Needed : Data withdrawal with comments

Dear Experts,


Here i need the solution


In an excel sheet 1 cell A1 with text "Senthil" and insert comment with "Quality Department"

When i call the cell in sheet2 D5 cell (=sheet1!A1) i got the answer Senthil but not the comment


Is there any method or technique to get the comment also
 
Senthilkumar_rm


Add this UDF to a code module in VBA

[pre]
Code:
Function Get_Comment(Src As Range) As Variant
Get_Comment = Src.Comment.Text
End Function
[/pre]

To use just use a formula: =Get_Comment(Sheet1!A1)


If you want the cells value and comment

Use: =Sheet1!A1 & Get_Comment(Sheet1!A1)
 
Back
Top