![]()
If Cells(1, 1).Comment Is Nothing Then MsgBox "this cell does not have a comment" Else If len(cells(1,1).comment.text) > 0 then MsgBox "this cell has a comment with text" Else Msgbox "this cell has a blank comment" End if End If
![]()
If Cells(1, 1).Comment Is Nothing Then MsgBox "this cell does not have a comment" Else If len(cells(1,1).comment.text) > 0 then MsgBox "this cell has a comment with text" Else Msgbox "this cell has a blank comment" End if End If
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks