using excel Visual Basic Code (VBA)

The program allows you to do the following:

1. Record a New Deposit

2. Record a Nee Withdrawal

3. Sum all current Deposits

4. Sum all current Withdrawals

The account is updated for any new deposits or withdrawals

Note: New Policy requires minimum of $100 balance at all times. A withdrawal which would cause the balance to be below this limit will not be performed.

** BASIC CODING, PLEASE USE COMMENTS TO EXPLAIN YOUR CODE TO MAKE IT EASIER TO INTERPRET**

.

Banking Account Management This program allows you to do the following: 1. Record a new deposit 2. Record a new withdrawal 3. Sum all current deposits 4. Sum all current withdrawls The account balance is updated for any new deposits or withdrawals. Note: new policy requires minimum of $100 balance at all times. A withdrawal which would cause the balance to be below this limit will not be performed. B E H K 1 Banking Account Management Exit New Deposit New Withdrawal Sum Deposits 5 Date Description 6 2-Jan paycheck deposit 7 5 Jan groceries 8 9 Jan clothing 9 12-Jan utilities 10 25-Jan paycheck deposit 11 30 Jan rent 12 5-Fob paycheck deposit 13 13-Feb utilities 14 19-Feb paycheck deposit 15 22-Feb groceries 16 25-Feb rent 17 1-Mar groceries 18 6-Mar paycheck deposit 19 13-Mer utilities 20 18-Mar paycheck deposit 21 22 Mar groceries 22 30-Mar rent 23 Amount $ 286.67 $(121.97) $ 95.89) 5(108.51) $ 285.67 $(350.00) $ 285.67 $ (99,34) $ 285.67 $(117.16) $(350.00) $ (66.81) $ 285.67 $(112.15) $ 285,67 $(110.14) $(350.00) $ 300.00 $ 500.00 $. 150.00 Balance $ 314.28 $ 192.31 $ 96.42 S (12.09) $ 273.58 $ (78.42) $ 209.25 $ 109.91 $ 395.58 $ 278.42 $ 71.58) $(138.39) $ 147.28 $ 35.13 $ 320.80 $ 210.66 $(139.34) $160.66 $660.66 $810.66 Sum Withdrawals 24 25 26 27 28 29 30 31 32 99 Account Welcome Account Banking Account Management This program allows you to do the following: 1. Record a new deposit 2. Record a new withdrawal 3. Sum all current deposits 4. Sum all current withdrawls The account balance is updated for any new deposits or withdrawals. Note: new policy requires minimum of $100 balance at all times. A withdrawal which would cause the balance to be below this limit will not be performed. B E H K 1 Banking Account Management Exit New Deposit New Withdrawal Sum Deposits 5 Date Description 6 2-Jan paycheck deposit 7 5 Jan groceries 8 9 Jan clothing 9 12-Jan utilities 10 25-Jan paycheck deposit 11 30 Jan rent 12 5-Fob paycheck deposit 13 13-Feb utilities 14 19-Feb paycheck deposit 15 22-Feb groceries 16 25-Feb rent 17 1-Mar groceries 18 6-Mar paycheck deposit 19 13-Mer utilities 20 18-Mar paycheck deposit 21 22 Mar groceries 22 30-Mar rent 23 Amount $ 286.67 $(121.97) $ 95.89) 5(108.51) $ 285.67 $(350.00) $ 285.67 $ (99,34) $ 285.67 $(117.16) $(350.00) $ (66.81) $ 285.67 $(112.15) $ 285,67 $(110.14) $(350.00) $ 300.00 $ 500.00 $. 150.00 Balance $ 314.28 $ 192.31 $ 96.42 S (12.09) $ 273.58 $ (78.42) $ 209.25 $ 109.91 $ 395.58 $ 278.42 $ 71.58) $(138.39) $ 147.28 $ 35.13 $ 320.80 $ 210.66 $(139.34) $160.66 $660.66 $810.66 Sum Withdrawals 24 25 26 27 28 29 30 31 32 99 Account Welcome Account