Access Access IRR Function on a Form

M

maxlee

Joined
Jun 20, 2012
Messages
1
Reaction score
0
Hello, I am trying to write a macro that will allow me to display the IRR of a series of cash flows in a text box on a form in Access 2010. The cash flows are also in individual text boxes that are all calculated controls. My initial script was

Private Sun
Static Values(10) As Double

Value(0) = Me.Text1
Value(1) = Me.Text2
Value(2) = Me.Text3
Value(3) = Me.Text4
Value(4) = Me.Text5
Value(5) = Me.Text6
Values(6) = Me.Text7
Values(7) = Me.Text8
Value(8) = Me.Text9
Value(9) = Me.Text10
Value(10) = Me.Text11

Me.Text12 = IRR(Values))

End Sub

If Im lucky there is only an error in the text box 12, but usually this ends up erroring out all my other text boxes that are calculated controls. any Ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Table Insert - VBA 2
Dynamic Crosstab - Repost 5
Dynamic Crosstab 3
Access I need help with a data entry form in Microsoft Access 97 2
Setting up function on access forms 1
Filter a continuous form using multi-select list box 8
Very basic ADO VB code on a Form 2
Resetting ComboBox on Form 3

Top