.AddComment ("Need Improvement")
End If
End If
End With
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: Mar/Wed/2012 03:38
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Conditional Commen
Hi,
Try it...
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$A$1" Or Target.Cells.Count > 1 Then Exit Sub
Target.ClearComments
If Target.Value = "XYZ" Then
Target.AddComment ("Good Work")
End If
If Target.Value = "PQR" Then
Target.AddCo
Dear All
Can I give conditional conmments.For Eg if In Cell A1 there is "XYZ" then
the comments show "Good Work" and If A1 contents "PQR" then comments should
show"need Improvement"
Is it possible ? if yes please let me know hoe to do it.
Waiting for reply
--
Shrini
--
FORUM RULES (986+ memb
