VBA calculation question

  • Thread starter Thread starter momiage
  • Start date Start date
M

momiage

I need to total numbers for a checkbook-like spreadsheet I am creating,
but I want to do it using vba and I am having a lot of problems.

the three columns I have running are withdrawls, deposits, and
balance.

I made a userform to enter in all the info.

I cant seem to to do a few things:

the form allows me to go back and add entries by date in case I forgot
to enter something, but then it screws up the balance column.

I need it to subtract the first entry from a starting balance (in f1)
and then from F6 down needs to calculate the balance. I tried to do it
so that a withdrawl would subtract, and a deposit would add, but somehow
I have it double counting things.
I figured I would just skip the code and put formulas in the
worksheets, but that got all messed up as well.

Also, I managed to find out how to insert a row so all of the 9/15/05
entires appear before the 9/16 entries (and so on), but it always
inserts the row up. I can make my code available to anyone willing to
help me. It is a mess right now, 10 hours of straight coding will do
that to you.

sorry if this is hard to read, I am really out of it right now. :(
 
Perhaps you could just have your macro recalculate the entire balance using
something like this:

Sub balance()
Set frng = Range("h8:h" & Range("a65536").End(xlUp).Row)
With frng
.Formula = "=h7+d8"
.Formula = .Value
End With
End Sub
 
Back
Top