[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
[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
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Posting Permissions
Reply With Quote