+ Reply to Thread
Results 1 to 8 of 8

Macro for Running Total in a cell that is clearable and not a comment?

  1. #1
    Registered User
    Join Date
    07-10-2017
    Location
    Kent, Ohio
    MS-Off Ver
    2016
    Posts
    4

    Macro for Running Total in a cell that is clearable and not a comment?

    Someone help?

    I am creating a budgeting tool for me to track my actual monthly expenditures and compare them to my monthly goals. I have my goals set and some pretty good formatting for that, however, i decided i wanted to put in a sheet where i can log my transactions daily in given headings.

    the objective is that i can click on a cell
    picture 1.PNG
    and add an expense, and it would just automatically add to the value in there previously.

    Doing this would allow me to reference the expenses i record on a later sheet, where it shows me the remaining funds to my goal, my goal itself, etc.
    Picture 2.PNG

    The problem im having is that i cannot find the proper help / code with my specific problem. i cant seem to code the cell for a simple running total within that cell, where i dont have access to a formula, but rather just type a number and it adds to the prior number.
    In addition, i would like to be able to add the macro to the other expense cells...

    Lastly, can i add a ClearContents macro to a button to clear just the values, or would it also delete the macro here? if it would delete the macro and not just the values ive recorded over a month, what else would i use?

    If i have made any sense to someone, please advise!!

    Antonio Sibbio

  2. #2
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Macro for Running Total in a cell that is clearable and not a comment?

    Hi ADSibbio

    Welcome to the Forum!!!

    Well, Pictures are of little value in testing any Code we may suggest...try this Code in the Worksheet Module of the Worksheet you wish to manipulate. You'll need to change Column References and Button References...attached is the File on which I tested.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Registered User
    Join Date
    07-10-2017
    Location
    Kent, Ohio
    MS-Off Ver
    2016
    Posts
    4

    Re: Macro for Running Total in a cell that is clearable and not a comment?

    Wow Thanks!!

    Its exactly what i need...But how to i apply it to the range of cells i would like to change? i opened your spreadsheet, and its exactly what im looking for...but whats the last step!!

    Antonio

  4. #4
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Macro for Running Total in a cell that is clearable and not a comment?

    Hi Antonio

    Be happy to help...

    Please attach a sample workbook the Structure of which is the same as your actual workbook.

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    INCLUDE ANY CODE YOU'RE USING OR HAVE TRIED.

    Remember to desensitize the data.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

  5. #5
    Registered User
    Join Date
    07-10-2017
    Location
    Kent, Ohio
    MS-Off Ver
    2016
    Posts
    4

    Re: Macro for Running Total in a cell that is clearable and not a comment?

    Ok Here you are!!

    The tab in question is called "Daily Entry." i wrote some notes in there as well...

    Thank you for your help so far, and im really excited to see if we can wrap it all up.

    Respectfully,
    Antonio
    Attached Files Attached Files

  6. #6
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Macro for Running Total in a cell that is clearable and not a comment?

    Hi Antonio

    I'm color blind so I'll explain what I did...moved this Code from a General Module to the Daily Entry Sheet Module and I've Locked and Protected Daily Entry for all Cells that are not Data Entry Cells (Column B only).
    Please Login or Register  to view this content.
    I've assigned this Code to your "Clear Transactions" Button on Sheet Transactions Summary and placed Formulas in Column B of the same Sheet...I've assumed that's why that Button is there.
    Please Login or Register  to view this content.
    Regarding this...
    Also can the cells be moved up / down if I choose to insert cells above it?
    Sure, it can be done either manually or with Code. Either manually or with Code you'll need to keep Sheets Daily Entry and Transactions Summary in synch.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    07-10-2017
    Location
    Kent, Ohio
    MS-Off Ver
    2016
    Posts
    4

    Re: Macro for Running Total in a cell that is clearable and not a comment?

    WOW! Excellent work man really...

    Thank you so much for your help!

    Time for me to start saving some cash

    -Antonio

  8. #8
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Macro for Running Total in a cell that is clearable and not a comment?

    You're welcome...glad I could help. Thanks for the Rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Adding running total macro
    By agzil in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-15-2016, 07:37 PM
  2. Problem with Running Total Macro
    By MeggieDoodles in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-19-2015, 03:16 PM
  3. running total cell macro
    By kpfeif in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2014, 10:30 AM
  4. [SOLVED] Macro for running total
    By prakashananth in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-01-2013, 10:26 AM
  5. How to set up running total in cell?
    By emspilot in forum Excel General
    Replies: 1
    Last Post: 09-01-2010, 03:54 AM
  6. Need help with a running total macro
    By Onyx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2009, 11:54 PM
  7. Keep a running total while using a clearable form
    By 1vagrowr in forum Excel General
    Replies: 3
    Last Post: 12-20-2005, 03:15 PM

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