How to set Textbox value = to a Percent ?

[needshelp12]

I am calculating various financial formulas, using UserForms in Excel 2010

I am declaring all values as doubles , which does not pose a problem for formulas like :

= nper( rate , Pmt, pv , fv)

Yet when it requires a percent like :

= pv( rate, nper, pmt, fv)

it only works if its in this format

= pv((6.5/12)%, nper, pmt, fv)


Here's my code:

Dim Value As String
Dim rate As Double
Dim nper As Double
Dim Fv As Double
Dim Pv As Double

rate = Rate1.Text
nper = NumPeriod1.Text
Pv = Pv1.Text
Fv = Fv1.Text

Value = Pmt(rate, nper, Pv, Fv)


Value = Format(Value, "Currency")
Payment1.Text = Value


Thanks !

 

[Ralajer]

I am assuming the input is typed as 6.5 thus the functions interpret that as 650% and not 6.5%. To fix that change the rate definition to.

rate = Rate1.Text / 100​

I am guessing though because you were not specific about what exactly was being returned (Error, Incorrect value, etc).