HELP PLEASE ----- Strait line and declining balance depreciation with VBA excel

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

I'm not sure what this has to do with VBA? It looks like you're just asking for a formula that you happen to be implementing in VBA.

Does a page like this help? If not, what help do you need specifically in VBA?

Hi
First thanks for your reply

well what i am trying to do is find a syntax that calculates the total depreciation from the start up to to date. i have found implemented the formula for depreciation but i cant figure out a way to add all the depreciation for the asset up to date in the cell and the same time the formula to be shown

Thanks again

You're probably going to need to post an example workbook with a description of where you are having issues.