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.