Hello shguser,
Welcome to the Forum!
Here is macro that will make sure both cells are zero if the user enters zero into either cell. You can the cells' addresses in the code to match the ones you are using. The changes are marked in red.
How to Save a Worksheet Event Macro
1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
3. Left Click on View Code in the pop up menu.
4. Paste the macro code using CTRL+V
5. Save the macro in your Workbook using CTRL+S
As a new member please take so time to familiarize yourself with the Do's and Don'ts here in the Forum, just click on the link below...
Forum Rules
Sincerely,
Leith Ross
Bookmarks