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

[helmekki]

i tried it but it did not work
i made a userform and placed textboxes on it and commandba
butten....but.....

could u hel

 

[Guest]

Hi helmekki

You need to set texrbox1 to an integer.
You can either do this in code with the
line I added or right click the textbox and
set the value in the properties box.

Also; add another command button and
paste Dave's suggested code, it will work
with the same textboxes on the form.
You might want to change the format
to ###.00

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

'add this line or cut and paste
TextBox1.Value = 0

box1 = (box2 - (box3 + box4))

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

End Sub

Good Luck
TK

 

[Dave Peterson]

I'm confused about what you tried and what you put in the textboxes when you
tried it.

You may want to post your code (and your data)--not the workbook.