Do Calculation with Form before I enter on worksheet

[Djblois]

I created a form for users to enter a number in but now I want need to do a math calculation before I enter it on the spreadsheet. This is what I tried:

[VBA]Range("B71").formular1c1 = (=PandL2.Interest1.Value*.01)[/VBA]

PandL2 is the form and interest1 is the textbox

[lucas]

[vba]Range("B71").FormulaR1C1 = (Interest1.Value * 0.01)[/vba]
what's up with the = sign?
this isn't formatted...it only puts a number in B71
if you use 100 in the textbox it will return only a 1

[Djblois]

I am doing the formating on the next line now

[Bob Phillips]

To get a value from a form's control, use

[vba]

Range("B71").Value PandL2.Interest1.Value*.01
[/vba]

but the form will still need to be loaded, otherwise it fails.

[lucas]

[VBA]Range("B71").FormulaR1C1 = Format(CDbl(Interest1.Value) * 0.01, "0.00%")[/VBA]