Reference a specific cell in the active row
I may not have a solution but I have a question...
<... 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.
If the activecell is anywhere in row 4 you want to campare to the value in
B4. And if the activecell is M27 you want to compare to B27?
Why the... etc.?
Did you mean activecell anywhere in row 27 compared to B27?
HTH
Regards,
Howard
"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
|