Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

No Negative Balance

0

<I have created a store ledger.

Aside the other columns, there are three main columns, namely, "Receipt" column, "Issue" column and finally the "Balance" column. Items received will be recorded in the "Receipt" column. Items issued out will be recorded in the "Issued" column. The "Balance" column keeps the running balance after "Issue" is deducted from "Receipt". I wish to set a threshold such that once the running balance reaches ZERO, users can't enter value on the "ISSUE" column. Put differently, I don't need negative balance as currently obtained. How can I achieve this? />

Answer
Discuss

Discussion

You have asked this question before. You received an answer to which you didn't respond. Follow the link I provide here, look at the solution that was offered, and if you don't like it use the Discussion section there to give voice to your reasons.
Variatus (rep: 4889) Nov 7, '17 at 8:28 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login