Results 1 to 7 of 7

How to Keep value of sum after deleting integer

Threaded View

ivander8 How to Keep value of sum... 03-30-2009, 12:53 PM
VBA Noob Re: How to Keep value of sum... 03-30-2009, 01:07 PM
modytrane Re: How to Keep value of sum... 03-30-2009, 01:38 PM
VBA Noob Re: How to Keep value of sum... 03-30-2009, 01:41 PM
modytrane Re: How to Keep value of sum... 03-30-2009, 02:02 PM
  1. #1
    Registered User
    Join Date
    03-30-2009
    Location
    Albuquerque, NM
    MS-Off Ver
    Excel 2007
    Posts
    3

    How to Keep value of sum after deleting integer

    I need help with what is probably a fairly easy VBA script, but i am new to VBA so, for lack of better words, I am stuck.

    What i need is a script that will add two boxes together to get a sum in a third box, but where it is tricky for me is that i need the third box to retain the summed value even when either of the first two box values are deleted.

    For example, say i have box A1=10, B1=40, and C1= SUM of A1 & B1 (so C1=50). Easy enough, but where im lost is that i want to be able to delete the value of either A1 or B1 and then have C1 still = 50, so then i can input another value into either A1 or B1 to continue to add to C1.

    I hope this I explained this halfway decent, and any help would be greatly appreciated!
    Last edited by ivander8; 03-31-2009 at 01:36 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1