This cell is manually entered. If an amount is entered manually by the user
into the cell and it's over $5,000, I want a pop up reminder.
Thanks.

"Mike H" wrote:

Hi,

The easiest way to do this would be using the worksheet change event but if
Column G is a calculated amount then that wouldn't call the sheet change
event code. Is G a calculation or is it manually entered. If calculated is
there another cell that is manually entered that could be used?

Mike

"chickalina" wrote:

I want to create a popup message for orders over a certain amount. We can
generally process purchase orders up to a certain value without a quote.
Anything over that I want a reminder that they need to email the quote to the
person entering the requisition. It's Column G in my spreadsheet.
Thanks for any help!
M