ExcelBanter - extract text from a comment

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - extract text from a comment (https://www.excelbanter.com/excel-programming/300338-extract-text-comment.html)

Sunil Patel

extract text from a comment

How does one extract the text from a comment in cell a1
to comment$ in VBA

Thanks
Sunil

kkknie[_131_]

extract text from a comment

Use:

comment$ = Range("A1").Comment.Text

K

---
Message posted from http://www.ExcelForum.com/

Bernie Deitrick

extract text from a comment

Sunil,

Dim myComment As String
myComment = Range("A1").Comment.Text
MsgBox myComment

HTH,
Bernie
MS Excel MVP

"SUNIL PATEL" wrote in message
...
How does one extract the text from a comment in cell a1
to comment$ in VBA

Thanks
Sunil

All times are GMT +1. The time now is 06:04 PM.