message box on cell value

[brauliocordova]

Hello All,

Not sure how to accomplished the following.

I need a message box (“amount exceeds”) to pop up in a range (D1:D30) when the value within this range is greater than 15. The change will happened Via formula not manually.

Thanks in advance
Braulio

[ajryan88]

Hi,

You can achieve this using data validation:
1. Select cells D1:D30
2. On the "Data" tab on the ribbon, select "Data Validation"
3. Under "Allow", select "Decimal" or "Whole Number" (whichever is appropriate)
4. Under "Data", select "less than or equal to" (or just "less than" if it is more appropriate)
5. Under "Maximum", type 15
6. Then change to the "Error Alert" tab in the dialog and customise your error message.
7. Click OK and test.

Happy days

Hope this helps

[ajryan88]

Sorry, scrap that last solution, I only just re-read your post and this can't be achieved using data validation due to the formula.

I will post a VBA solution for you in a moment

[ajryan88]

Try pasting this code into the worksheet module of your workbook:

Please Login or Register  to view this content.

Hope this helps