AK,

An easy way is to put this in a cell:

=IF(OR(B2:B65536="NY"),"Talk to Bob", "")

Enter as an array formula (Use Ctrl - Shift - Enter, not just Enter).

It's best put at the top of the worksheet in the freeze pane area, if you
have one, so it doesn't get scrolled off the screen.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"AK" wrote in message
...
Based on the entry in a cell in a column (B), how would a message box
appear
based on the entry.

Example:
If B2 = "NY", message box would appear, "Talk to John"
or if B5000 = "NY" same message would appear

Message box should appear for "NY" in the column and not a specific cell.

Thank you in advance