Hi,

I'd like to have a message box popup whenever the word INPUT appears in a
certain cell.

Cell A1 have a formula to lookup another cell. If that cell does not have a
value, cell A1 will show the word INPUT. Whenever A1 shows INPUT, i want a
message box to appear to request for user input.

I know how to create the form for the input and i know how to place the
input value into cell A1, but I just do not know how to get the message box
to popup.

Also, I need excel to automatically monitor row by row, ie, users will key
in row by row. So, if A1 shows INPUT, the message box will appear. then after
they key in the INPUT and go on to the next row, if A2 shows INPUT again,
another message box will appear.

Thanks.

Dolphin