Re: Pop-Up Message

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" <Cutter.1zc0ha_1133391002.2981@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:Cutter.1zc0ha_1133391002.2981@xxxxxxxxxxxxxxxxxxxxxxxx
>
> 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
>
>
> --
> Cutter
> ------------------------------------------------------------------------
> Cutter's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=9848
> View this thread: http://www.excelforum.com/showthread.php?threadid=489619
>


.

Relevant Pages

  • Re: check userform values in combination
    ... MsgBox "Not found" ... I have a userform with a number of combo boxes. ... The cell may also be ... I plan to make a warning appear. ...
    (microsoft.public.excel.programming)
  • Re: Add text based on imput in another cell
    ... The problem as I saw it was, if the warning ... That means when the user leaves the cell, ... went to edit the text in C21 and restore it when they were finished. ... Private Sub Worksheet_SelectionChange ...
    (microsoft.public.excel.programming)
  • Re: Add text based on imput in another cell
    ... The problem as I saw it was, if the warning were allowed to remain during editing, there would be no practical way to protect if from being modified. ... Consider if the user accidentally deleted the closing parenthesis from the warning message... ... That means when the user leaves the cell, a new warning message would be added to the remaining text in the cell. ... To protect the warning message against this scenario, I decided to remove it when the user went to edit the text in C21 and restore it when they were finished. ...
    (microsoft.public.excel.programming)
  • Re: Drop down list error after edit
    ... use the menu command Data - Validation... ... go to the Error Alert tab, and change the style to Warning. ...
    (microsoft.public.excel)
  • Re: copying named cells into new workbook
    ... If you are using the GUI, the warning you refer to cannot be ... Sub testIt() ... > without having the origin file name pasting in as well? ... > cell named XYZfrom One.xls into Two.xls will Two.xls have a cell called ...
    (microsoft.public.excel.programming)