Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - DETECT CELL COMMENT IN VBA
What VBA statement(s) can I use to determine whether or not a specific cell
has a comment attached to it? Please reply directly to Thanks Al Baker |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - DETECT CELL COMMENT IN VBA
Al, here is one way,
Sub Check_For_Comment() Dim cm As Comment Set cm = ActiveCell.Comment If cm Is Nothing Then MsgBox "No Comment In Cell " & Selection.Address, , "Comment ?" ElseIf Not cm Is Nothing Then MsgBox "Comment In Cell " & Selection.Address, , "Comment ?" End If End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Al Baker" <Al wrote in message ... What VBA statement(s) can I use to determine whether or not a specific cell has a comment attached to it? Please reply directly to Thanks Al Baker |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB ; How do I detect a Comment in a cell | Excel Discussion (Misc queries) | |||
detect cell change | Excel Programming | |||
How to detect if a cell is formula | Excel Programming | |||
Detect Comment + Happy Christmas | Excel Programming | |||
Detect when Active Cell Changes | Excel Programming |