am new to VBA in Excel. need to show sum and not concatenated values
have a userform w 60 fields for numbers as follows:
a) UserForm1.TextBox34 to UserForm1.TextBox41: 8 fields-CAD currency
b) UserForm1.TextBox42 to UserForm1.TextBox49: 8 fields-USD currency
c) UserForm1.TextBox50 to UserForm1.TextBox57: 8 fields-exchange rate
d) UserForm1.TextBox58 to UserForm1.TextBox65: 8 fields-Total CAD currency => the formula here works across the board
UserForm1.TextBox58.value = Format(UserForm1.TextBox34.value+UserForm1.TextBox42.value*UserForm1.TextBox50.value, "###,##0.00")
e) UserForm1.TextBox66 to UserForm1.TextBox73: 8 fields-local taxes in CAD currency
f) UserForm1.TextBox74 to UserForm1.TextBox81: 8 fields-federal taxes in CAD currency
g) UserForm1.TextBox82 to UserForm1.TextBox89: 8 fields-total for first column in CAD => the formulas here works as well across the board
UserForm1.TextBox82.value = Format(UserForm1.TextBox34.value + UserForm1.TextBox42.value * UserForm1.TextBox50.value + UserForm1.TextBox66.value + UserForm1.TextBox74.value, "###,##0.00")
have a grand total formula pulling in all values, and this one works as well; so i have 4 simple addition formulas, and the local & fed tax formulas do not.
however, the formulas for the sub-total for the local taxes and the federal taxes do not work; the results show a concatenation of the 8 values rather thn the sum of the 8 values; the formula for the local tax is as follows:
UserForm1.TextBox110.Value = Format(UserForm1.TextBox66.Value + UserForm1.TextBox67.Value + UserForm1.TextBox68.Value + UserForm1.TextBox69.Value + UserForm1.TextBox70.Value + UserForm1.TextBox71.Value + UserForm1.TextBox72.Value + UserForm1.TextBox73.Value, "0.00")
have rewritten the formulas and still these two tax formulas result in concatenated numbers rather than the sum.
appreciate any assistance on the above.
would have u/l worksheet but it's roughly 4MB now.
thank you..
rmon
Bookmarks