VBA issue with form clearing

[maxhardcore23]

Fellas,
I'm hoping to get some assistance with a delivery spreadsheet I have downloaded and manipulated to fit my needs for fuels delivery records. The input sheet which is the first tab is saving VBA code when you "new" or "submit" but not when you "change" or "delete". Some of the problem code be the mixture of excel formulas and VBA but I am just beginning to use VBA and have not made any of my own sheets yet. I hope to learn but I am running out of time.

I was wondering if anyone is willing to help me out, I am willing to work outside the forums if you would like.

See below 2222 Propane deliveries ticket sheet-Good 22222.xls

[walruseggman]

What do you need help with?

[maxhardcore23]

I can't figure out the VBA code to protect the input information from disappearing in the first sheet when I use the Delete and Change buttons.It isn't doing it on the new and submit buttons. I have tried adjusting the ranges and changing VBA code ranges as well but I'm not familiar enough with how to do that or what to recognize is the issue.

I need to roll the acct # and prices onto a new form with out deleting formulas or code.

Any help would be greatly appreciated.
Thanks2222 Propane deliveries ticket sheet-Good 22222.xls