| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cell comments
Hi
Is there a way to check if a cell has a comment which contains a string? What I want to do (in pseudo code) is Code:
If Range("A1").comment.text contains "My String" Then
'Do Stuff
End If
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell comments
Hi,
Am Thu, 5 Feb 2015 09:55:23 +0000 schrieb davidman: Is there a way to check if a cell has a comment which contains a string? try: Sub CommentCheck() With Range("A1") If Not .Comment Is Nothing And _ InStr(.Comment.Text, "MyString") Then 'Do stuff End If End With End Sub Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract Cell Comments and Paste as text in a cell | Excel Worksheet Functions | |||
| excel 2000 how to format the comments font all comments | Excel Discussion (Misc queries) | |||
| Creating Macro to copy information from cell into another cell using Add Comments | Excel Programming | |||
| Need to add cell comments in unlocked cell on protected worksheet | Excel Discussion (Misc queries) | |||
| UDF code to find specific text in cell comments, then average cell values | Excel Programming | |||
Linear Mode
