I have no idea why excel vba is doing this.
TextBox_Sum.Value = TextBox_Body + TextBox_Components
So the textbox sum is supposed to add the amount in textbox_body and the amount in textbox_components. But that doesn't happen, instead, excel puts them together and treats it as a string. For example textbox_body has a value of 2.5 and textbox_components is 2.7, instead of getting 5.2 it returns 2.52.7 !!
I also tried
TextBox_Sum.Value = TextBox_Body.value + TextBox_Components.value
and
TextBox_Sum.Value = val(TextBox_Body.value) + val(TextBox_Components.value)
but none of those worked.
it may be important to note that the values textbox_body and textbox_components are extracted from an excel sheet like so:
TextBox_body = cells(1,1)
What am i doing wrong here?


Bookmarks