Hi guys
how do i check if a cell has comments in VBA?
using this but it dosnt like it if there is no comment.![]()
If Cells(ActiveCell.Row, 9).Comment.Text <> "" Then
Hi guys
how do i check if a cell has comments in VBA?
using this but it dosnt like it if there is no comment.![]()
If Cells(ActiveCell.Row, 9).Comment.Text <> "" Then
Last edited by FRIEL; 07-18-2011 at 12:37 PM.
I dont like to use code i dont understand
it makes it hard to use in other situations
so please try to be as clear and patent as possible with me
Criticism is welcomed
My bad I sorted it
Here
![]()
Sub X() With ActiveCell If Not .Comment Is Nothing Then If .Comment.Text <> "" Then MsgBox "Comment with text " & vbLf & .Comment.Text, vbInformation Else MsgBox "Comment with no text", vbExclamation End If Else MsgBox "No comment", vbCritical End If End With End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks