Hello Friends....
I have a question I need to rewrite my code which I made in Expression and need to convert to VBA, if it is available:
the idea is: I Placed this code on unbound text box "Depreceation" in "DeprPercent" I enter the percent eg: 18% or 20% and after that it calculates yearly.
Thanks In Advanced
I have a question I need to rewrite my code which I made in Expression and need to convert to VBA, if it is available:
Code:
=[UnitPrice]*(((100-[Deprpercent])/100)^Int(Format(Date(),"yyyy\.mmdd")-Format([DateOfPurchase],"yyyy\.mmdd")))
the idea is: I Placed this code on unbound text box "Depreceation" in "DeprPercent" I enter the percent eg: 18% or 20% and after that it calculates yearly.
Thanks In Advanced