help on vba code please

[mushmoom]

I am trying to write code to workout the asset depreciation and the fields I got are as fellow
1 2 3 4
COST DEP IN MONTH DEP IN YEAR NET VALUE
1*% ADD ALL MONTHS I-3

That was one sort of dep and the secont is

1 2 3 4

COST DEP IN MONTH DEP IN YEAR NET VALUE

1*% ADD ALL MONTH 1-3

DO THIS TILL THE NET VALUE IS NIL CAN SOME ONE HELP ME WITH THIS