Add or subtract from total

Hi there, I need help with an inventory spreadsheet I'm trying to create. Here's the scenerio.

CELL A1=45

I want CELL A2 to be a blank cell which people can enter a number in that will decrease the value of A1 and once that value is entered, it would return to a blank cell. CELL A3 would be used in the same fashion except to increase the value of A1

what would a formula for this look like?

thanks much!
John

This is a VBA question. Are you OK with turning on macros on your workbook? If so:

1) Right-click on the sheet tab and select VIEW CODE
2) Paste in this sheet-event macro to the window that appears:

Please Login or Register  to view this content.

3) Close the editor and save your workbook (as a macro-enabled workbook if you're using Excel 2007...please fill out your profile)


Try changing values in A2 and A3.

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)

Thanks, initially I didn't think this was a VB thing, just a formula..Maybe I'm getting in over my head but I need to calculate more cells in the same sheet, so I tried to copy the code and change the values to the cells I need but I kept getting errors "ambigious name detected" or it just didn't work at all...Here's what I tried..How would i add more cells onto this subroutine?

Please Login or Register  to view this content.

John, be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to edit that post above and put code tags around that code you used. (Like I did in my posts...) Look in my signature for an example of how to wrap the code in tags.

Go ahead and fix that then I'll show you how to get multiple events into the one ws_change macro.

Here you go: Adjust the range as needed:

Please Login or Register  to view this content.

I'm surprised you didn't at least try to add the new sections into the code, it's nothing more than a cut-n-paste job/change the ranges...

Please Login or Register  to view this content.

Hi Soso277B and welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.