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.
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.