Thank you Rick.

This has got it just about where I want it. The only issue I am having now
is, even though it generates a comment, the comment box never appears, the
triangle just shows up in the corner of the cell but does not give the user a
chance to type anything.

I don't want the comments to always remain visible, that would just create
too much clutter. I am trying to get it to appear so the user can enter
comments and then disappear when they move to the next cell.

"Rick Rothstein" wrote:

Try it this way...

If Target.Value < Cells(Target.Row, "B").Value Then

--
Rick (MVP - Excel)


"dweber1188" wrote in message
...
I am trying to write a code that will generate a comment box if the user
enters a value not equal to the value I set. All my values are entered in
column B. How do I need to word the code so that if the active cell is
anywhere on row 4, the cell value is compared to B4, If the active cell is
M27 then its value is compared to B27, etc.

This is the portion of the code I am talking about.

If Target < WHAT DO I PUT HERE??? Then
With Target
.AddComment
.Comment.Text Text:=Application.UserName & ":" & Chr(10)
.Comment.Visible = True
End With
End If

.