Return a formula
glad you got it working.
--
Gary
"Patrick Simonds" wrote in message
...
Thanks.
This is how the finished code looked:
Worksheets("Income").Range("B3").Formula = "=" & TextBox80.Value
"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i changed it up because i don't have your code, but this worked for me when i
clicked a commandbutton on the form after entering 10+10 into textbox1
Private Sub CommandButton1_Click()
Worksheets("Sheet2").Range("B3").Formula = "=" & UserForm1.TextBox1.Value
End Sub
--
Gary
"Patrick Simonds" wrote in message
...
Is there any way to force this to be a formula when it is placed in cell B3?
I want someone to be able to enter say 10 + 10 and have the result be 20 in
cell B3. I know you can enter =10+10 and it will return 20, but I can not
count on everyone remembering (knowing to use) the = sign.
Private Sub TextBox80_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Worksheets("Income").Range("B3").Value = TextBox80.Value
End Sub
|