spreadsheet functions

[makako]

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]

You can still use it..

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

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

[makako]

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]

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]

maybe im not explaning my self, the spreadsheet cant have addin funtions?
I posted what im trying to do