PDA

View Full Version : spreadsheet functions



makako
10-24-2006, 09:18 AM
Hi, Im trying to use funtions in a spreadsheet inside a userform. The financial function (Present Value) asks for Values, Dates and the Rate. I use it to calculate cash flows etc. In Excel one has to select the advanced analysis to be able to use it but being the formula in the web component, how do i install it?

Zack Barresse
10-24-2006, 03:44 PM
You can still use it..

Application.WorksheetFunction.Pv(Arg1, Arg2, Arg3, [Arg4], [Arg5])

Just replace each argument (ArgX) with your objects (i.e. Me.TextBox1.Value). Is that waht you are talking about?

makako
10-25-2006, 02:11 PM
Thanks Firefytr, but no. I dont need the value in my spreadsheet, I need the actual formula (in my "Spanish" version of Excel = ) VNA.NO.PER

Zack Barresse
10-30-2006, 02:34 PM
You can't do that. The only thing you can do is simulate it with objects, or (post 97 versions) use a modeless userform and allow interaction between the spreadsheet and the userform(s).

makako
10-30-2006, 06:47 PM
maybe im not explaning my self, the spreadsheet cant have addin funtions?
I posted what im trying to do