Pop-Up Message

[Guest]

I would like to have a warning message pop-up when a dollar value is exceeded.
When a user enters a value of $2500 or more in a cell, I would like to have
a message display that tells them they must have certain documents to backup
that value.

Is there a way to do this? All I can find is in DATA - Validation - INPUT
MESSAGE.
It comes up as soon as you select the cell, not what I want.

Thanks in advance.

 

[Cutter]

You're on the right track.

Use Data - Validation
On the Settings tab under "Allow" choose Custom
In the "Formula" area type: =A1<=2500
(Change the A1 to whatever cell you're working with)

Now on the Error Alert tab in the "Style" area choose Warning
Then type in a title and text for your warning
Click OK

 

[Bernard Liengme]

Have you tried Data Validation?
Set the Allow box to Decimal or Whole Number as fits your need
Set min to 0, max to 2500 and add Error Alert message

OR add just an Input Message so that a message shows up when the cell is
selected
best wishes

 

[Biff]

Hi!

That will prevent any value >2500 from being entered. I think the OP wants
to allow any value.

You could use an event macro with a msgbox (I can't help with that) or maybe
use a cell:

=IF(A1>=2500,"Amounts over $2500 require documentation","")

Biff

 

[Cutter]

Biff

It will not "prevent" a value over 2500. If a value greater than 2500
is entered then the message pops up. Because it's a "warning" and not
an "error" the message adds the question "Continue?" and there are 3
options - Yes, No, Cancel.

If you choose Yes then the value entered is accepted. I believe that
fits what the OP requires.

 

[Biff]

I didn't read your reply closely enough!

You are correct.

Biff