Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
extract text from a comment
How does one extract the text from a comment in cell a1
to comment$ in VBA Thanks Sunil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
extract text from a comment
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
refer a cell text in b1 and extract remaing text from a1 | Excel Discussion (Misc queries) | |||
How to extract text from number/text cell | Excel Worksheet Functions | |||
Comment Text | Excel Discussion (Misc queries) | |||
Text from a comment box into a cell | Excel Worksheet Functions | |||
Sheet direction, extract data from comment | Excel Worksheet Functions |