textbox to integer

[jhnnyboz]

hey i am trying to calculate the water/ cementious ratio using a user form and for some reason vba is saving the textbox entry to a text so then why i try to add three inputs together say for 1,1,1 it gives me 111 instead of 3. but i have another input that it will subtract and divide just fine.

please help

[VBA]

Dim course, fine, cement, water1 As Integer

'calculate
course = w1 - w1 / (1 + m1 / 100)
fine = w2 - w2 / (1 + m2 / 100)
cement = course + fine + cement1 + pozz
water1 = 8.33 * (addedwater + batchwater + meterwater)
cwratio1 = water1 / cement
MsgBox course
MsgBox fine
MsgBox water1[/VBA]

it will calculate the course and fine as integers but the water1 it will give me the "111" instead of 3.

[CatDaddy]

you can try CInt on your variables in case one is a string

[CatDaddy]

+ is also a concatenation operator on strings

[jhnnyboz]

oh that makes sense.

can you post the code for cint, i am not familiar with that.

[CatDaddy]

i assume you have something like
[VBA]w1 = textbox(blahblahblah)[/VBA]

change it to
[VBA]w1 = CInt(textbox(blahblahblah))[/VBA]

[CodeNinja]

Jhnnyboz,
Just a note, I see you are using integers, but you may want to consider using doubles instead of integers....

With an integer, any fractions are rounded. If you want this that is fine, but some of your calculations look like they need decimal values. If you were to change all or some of the variables to doubles, it may give you more accurate calculations.

Of course you could use cdbl() the same way as you use cint() to convert a string or value to a double.

Good luck.

[CatDaddy]

^^true, i did not even consider that