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

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
 
G

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Arbitrary data to Textboxes in UserForm 4
Textbox1.Value Question 2
print labels from userform 4
Userform and Goal Seek 1
How to calculate data that is entered into a text box 1
TextBox1.value=TextBox2.value-(TextBox3.value+TextBox4.value) 2
Create a public variable 4

Top