jhnnyboz
06-18-2012, 09:35 AM
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
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
it will calculate the course and fine as integers but the water1 it will give me the "111" instead of 3.
please help
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
it will calculate the course and fine as integers but the water1 it will give me the "111" instead of 3.