here it goes - is it possible to have a comment automatically appear in a
cell if the info entered meets certain criteria?

Greg

You could use the message in Data Validation


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site' (http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=103405

Yes. Right click on sheet tab, view code, paste this in. Adjust as necessary.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target Is Nothing Then Exit Sub

'Change this to your criteria
If Target.Value = "Bob" Then
With Target
.AddComment

'Set this to true if you want
'comment visible all the time
.Comment.Visible = False

'Change text to whatever you want comment to be
.Comment.Text Text:="My comment" & CHAR
End With
End If

End Sub
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Greggo G" wrote:

here it goes - is it possible to have a comment automatically appear in a
cell if the info entered meets certain criteria?

Greg

Thanks Luke - I'll play around and see if I can get it to work (still have a
whole lot to learn about VBA)

"Luke M" wrote:

Yes. Right click on sheet tab, view code, paste this in. Adjust as necessary.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target Is Nothing Then Exit Sub

'Change this to your criteria
If Target.Value = "Bob" Then
With Target
.AddComment

'Set this to true if you want
'comment visible all the time
.Comment.Visible = False

'Change text to whatever you want comment to be
.Comment.Text Text:="My comment" & CHAR
End With
End If

End Sub
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Greggo G" wrote:

here it goes - is it possible to have a comment automatically appear in a
cell if the info entered meets certain criteria?

Greg