Alert User To Stop As Sum Amount Has Reached

words4you

New Member
Joined
Nov 23, 2008
Messages
5
Greetings...

I have a petty cash request. The maximum sum of a single request is 2,000. The user will enlist voucher details with different amount. When the sum of the invoices has reached the ceiling, the user should stop adding more invoices. The remaining invoices would therefore be accounted upon the next request.

I would be more than happy if anybody could please help me. I want Excel to display a pop-up message to alert the user that the ceiling amount has been reached and also TO PROHIBIT further addition of invoices.

I understand that this would entail VBA...

Thank you.
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,003
2200
AMOUNTS THAT WILL BE SUBMITTED
inv1900900
inv2700700
inv36002000 limit reached
use col j to transfer invoice details

<colgroup><col width="64" span="14" style="width:48pt"> </colgroup><tbody>
</tbody>
 

Watch MrExcel Video

Forum statistics

Threads
1,108,624
Messages
5,523,966
Members
409,547
Latest member
AW2020

This Week's Hot Topics

Top