• 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.

Is there any way to extract comments (cell comment) using formula

Try this non-VBA solution to capture a cell comment :

1] Assuming you have a Comment on cell A1

2] Select Cell C1 >> Define Name

2.1] "Name", enter : DisplayComment

2.2] "Refer to", enter formula :

=GET.OBJECT(12, ROW(A1))

3] In cell C1, enter formula :

=DisplayComment

Regards
Bosco
 
Thanks Bosco, Unfortunately not working :( , could you please share the some urls around get function and its functionality

bosco_yip said:
Try this non-VBA solution to capture a cell comment :

1] Assuming you have a Comment on cell A1

2] Select Cell C1 >> Define Name

2.1] "Name", enter : DisplayComment

2.2] "Refer to", enter formula :

=GET.OBJECT(12, ROW(A1))

3] In cell C1, enter formula :

=DisplayComment

Regards
Bosco
Click to expand...
 
You must log in or register to reply here.
Back
Top