Thread
:
Check Excel Comment
View Single Post
#
1
April 26th 06, 12:34 AM posted to microsoft.public.outlook.program_vba
Bob Smith
external usenet poster
Posts: 34
Check Excel 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 = "1"
Cells(A,1).Comment.Delete
Else
Cells(A,1).AddComment
Cells(A,1).Comment.Text("My Text")
Bob Smith
View Public Profile
View message headers
Find all posts by Bob Smith
Find all threads started by Bob Smith
Ads