Hi there,

I wonder if someone can help me with code to deal with a particular
issue:

I have two columns of cells which capture two different pieces of data
in real time. Call them X and Y, with an X and a Y in every row (or
most rows). One of the pieces of data comes with a time stamp in the
data source. The other piece of data I time stamp through VBA code
(i.e. checking when that part of the worksheet changes and saving that
time). So both X and Y have a column saying what time they arrived.

What I need to do is, checking the entire column of individual X and Y
values on a by-row comparison is "If X Y and the time X arrived is
after the time Y arrived then pop up a message box saying 'X exceeded
Y at zz:zz time."

Obviously it would be easy to make a cell which could compare X and Y
and the times, but I need to do this through code because I need the
message box to have the detailed info about X and Y and the times at
the moment the message is triggered. And also because X and Y will
change frequently so a cell without a persistent message (until
someone closes it) is likely to be missed.

any help would be greatly appreciated!

if you can, please e-mail me directly in addition to responding to the
group.

thanks in advance,
Ross