View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick Simonds Patrick Simonds is offline
external usenet poster
 
Posts: 258
Default Return a formula

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