View Single Post
  #2  
Old April 26th 06, 06:27 AM posted to microsoft.public.outlook.program_vba
Michael Bauer
external usenet poster
 
Posts: 435
Default Check Excel Comment

Am Tue, 25 Apr 2006 15:34:01 -0700 schrieb Bob Smith:

Bob, IŽm sure youŽd get an answer in an Excel related group, e.g. in:
microsoft.public.excel.programing

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


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")

Ads