View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Smith[_3_] Bob Smith[_3_] is offline
external usenet poster
 
Posts: 3
Default Excell Add Comment

How do I check if a Cell has a comment field in VBA before I try and ADD a
comment?

e.g.

if Cells(A,1).Comment = True
Cells(A,1).Comment.Delete
Else
Cells(A,1).AddComment
Cells(A,1).Comment.Text("My Text")