+ Reply to Thread
Results 1 to 7 of 7

Calculation Running Balance

  1. #1
    Registered User
    Join Date
    02-19-2021
    Location
    Pakistan
    MS-Off Ver
    2013 and 2016
    Posts
    19

    Calculation Running Balance

    I was Created a userfrom for invoice control. in this userform i was created 3 Textbox.
    Textbox1 For Old Running Balance
    Textbox 2 For Current Bill
    Textbox 3 For Result,
    now i want to VBA Coding for If Customer running Balance in Debit then Texbox1 + Textbox2 if Customer Running Balance is Credit then Textbox1 - Textbox2 and show the Result in Textbox3 Please Help

  2. #2
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Calculation Running Balance

    Welcome to the forum

    Can you please upload a sample workbook and a manual output that needs to be automated?

    The process of uploading sample file is given at the top of the forum in Yellow.
    Teach me Excel VBA

  3. #3
    Registered User
    Join Date
    02-19-2021
    Location
    Pakistan
    MS-Off Ver
    2013 and 2016
    Posts
    19

    Re: Calculation Running Balance

    Thanks For Welcome...

    Imran Dear . here is a sample file. i want to calculate values of these just for seen the customer running AR.
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Calculation Running Balance

    Cross-posted:
    https://www.mrexcel.com/board/thread...ation.1162419/

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)... I provided the cross-posted link this time.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  5. #5
    Registered User
    Join Date
    02-19-2021
    Location
    Pakistan
    MS-Off Ver
    2013 and 2016
    Posts
    19

    Re: Calculation Running Balance

    Sorry for that .. next time i shall avid this
    i shall not post anywhere same post.

  6. #6
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Calculation Running Balance

    Quote Originally Posted by AsifShah View Post
    Sorry for that .. next time i shall avid this
    i shall not post anywhere same post.
    You are allowed to cross-post. Just provide links to all the sites you posted on so we don't answer a question that may already have an answer.

  7. #7
    Registered User
    Join Date
    02-19-2021
    Location
    Pakistan
    MS-Off Ver
    2013 and 2016
    Posts
    19

    Re: Calculation Running Balance

    Oke Dear next time i shall ...

+ 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] running balance %
    By makinmomb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-22-2019, 08:48 AM
  2. [SOLVED] Running Balance does not match Total calculation
    By Kat2016 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-19-2016, 05:36 PM
  3. IF function for running balance that wont show starting balance in all cells
    By Heather T in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-11-2015, 03:15 PM
  4. Running balance
    By deejaychi in forum Excel General
    Replies: 1
    Last Post: 02-07-2013, 04:17 PM
  5. Running balance
    By meddyliol in forum Excel General
    Replies: 4
    Last Post: 07-03-2010, 11:27 AM
  6. Running Balance Calculation - with timestamp parameters
    By Push Latency in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-30-2007, 04:19 PM
  7. [SOLVED] rent received/balance owed/running balance spreadsheet
    By Quickbooks dummy in forum Excel General
    Replies: 1
    Last Post: 01-02-2006, 03:40 PM

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