hi all

TextBox1.value=TextBox2.value- (TextBox3.value+TextBox4.value)

how to make this works in a code?

And the TextBox1 should show the result of the formula........

yours


--
helmekk

-----------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...nfo&userid=693
View this thread: http://www.excelforum.com/showthread.php?threadid=26909

textbox1.value = format(cdbl(textbox2.value) _
-(cdbl(textbox3.value)+cdbl(textbox4.value)),"000.0 0")



helmekki wrote:

hi all

TextBox1.value=TextBox2.value- (TextBox3.value+TextBox4.value)

how to make this works in a code?

And the TextBox1 should show the result of the formula........

yours
h

--
helmekki

------------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=269094

--

Dave Peterson

HI helmekki

If you like to declare varibles
here's another suggestion.
The code can be as crude as the following,
and will work on a form or sheet.

Private Sub CommandButton1_Click()

Dim box1 As Integer
Dim box2 As Integer
Dim box3 As Integer
Dim box4 As Integer
box1 = TextBox1.Value
box2 = TextBox2.Value
box3 = TextBox3.Value
box4 = TextBox4.Value

box1 = (box2 - (box3 + box4))

MsgBox box1, , "Good Luck TK"
TextBox1.Value = box1

End Sub

Good Luck TK


" helmekki wrote:

hi all

TextBox1.value=TextBox2.value- (TextBox3.value+TextBox4.value)

how to make this works in a code?

And the TextBox1 should show the result of the formula........

yours
h

--
helmekki

------------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=269094

--

Dave Peterson