extract text from a comment

[SUNIL PATEL]

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

Thanks
Sunil

 

[kkknie]

Use:

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

K

 

[Bernie Deitrick]

Sunil,

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

HTH,
Bernie
MS Excel MVP