Alert User To Stop As Sum Amount Has Reached

[words4you]

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.

 

[oldbrewer]

				2200
									AMOUNTS THAT WILL BE SUBMITTED
			inv1	900					900
			inv2	700					700
			inv3	600	2000 limit reached
													use col j to transfer invoice details

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