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

  • Thread starter Thread starter helmekki
  • Start date Start date
H

helmekki

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

could u hel
 
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
 
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.
 
Back
Top