Worksheet change event code to display message box based on active cell offset content

[Nitefox]

I am trying to use the following Worksheet_Change event code to display a message box when the user types data in a G cell (within the range), and if the F cell on the row below contains "LAST ROW", but its not working:

Please Login or Register  to view this content.

[judgeh59]

will this help....it seem to work on the data set I created....ALSO, LAST ROW must be exactly LAST ROW because LAST ROW is not the same as Last Row....you can "wrap" the Rng.Offset(0,-1).value in a UCASE function so no matter how it's in the cell it will convert it to upper case....HTH

Please Login or Register  to view this content.

EDIT: In your next post you might want to explain the problem a little more than "it doesn't work"....because that could mean a lot of things....have a great day