| 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
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
extract text from a comment
|
| 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 | |||
Hybrid Mode
