Thanks very much,
What I am trying to do is by inserting a value in textbox1, it runs the code
and places the result in textbox2.
Textbox1 is linked to cell sheet1 "A1" and textbox2 is linked to Sheet1 cell
"A2"
I'v tried using formula, but every time I enter a value in textbox1, it
clears the formula in cell "A2"
--
Tdp


"David Biddulph" wrote:

I'll let someone else answer the VB question, but as a formula you don't
need the SUM() function.
=(1013-J5)*28 will do.
--
David Biddulph

"Tdp" wrote in message
...
How You put the following as a vb code:

=SUM(1013-J5)*28


--
Tdp