PDA

View Full Version : Solved: Excel Comments item



lynnnow
11-20-2007, 11:40 PM
Hi,

Is there a way to find out if a cell is commented or not? I've looked in the help files, but I've not found it. Can anyone help :help

Lynnnow

Bob Phillips
11-21-2007, 12:32 AM
Dim cmt As Comment
On Error Resume Next
Set cmt = ActiveCell.Comment
On Error GoTo 0
If Not cmt Is Nothing Then
MsgBox "commented"
End If

lynnnow
11-21-2007, 12:55 AM
Thanks xld. It works perfectly. Just what I was looking for.
:clap:
:bow:
:friends: