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