Isaac Fiifi Ferguson
New Member
- Joined
- Apr 5, 2023
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Please I seriously need a VBA code for my inventory user form.
This code should avoid negative stock balance. It should prompt and avoid me from making sales more than available in stock.
Below will help your understanding to my request.
This code should avoid negative stock balance. It should prompt and avoid me from making sales more than available in stock.
Below will help your understanding to my request.
(A) | Product Name | Opening Stock | Purchase | Sales | Closing Stock |
Apple | 85 | 0 | 100 | -15 | |
Watermelon | 26 | 0 | 15 | 11 | |
Sugarcane | 13 | 0 | 28 | -15 | |
Banana | 50 | 0 | 5 | 45 | |
Pawpaw | 77 | 0 | 80 | -3 |