Hello guys

I have currently started studying VBA in excel and macros and i have a project to do for the straight line and declining balance depreciation but i have problem with finding the formula for the total depreciation in the end of the period. The variables involved are Acquisition date, gross value, lifetime, salvage value,
could you please help me????
Thanks in Advance