Thread
:
Excell Add Comment
View Single Post
#
1
Posted to microsoft.public.excel.programming
Bob Smith[_3_]
external usenet poster
Posts: 3
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")
Reply With Quote
Bob Smith[_3_]
View Public Profile
Find all posts by Bob Smith[_3_]