Adding values of 2 text boxes

[isaacv22]

Hello I'm trying to add the value of two textboxes, but it's just combining the values together instead of giving me the sum. For instance if the value in the txtSeries is 7000 and the value of txtSurface is 700 it shows up as 7000700 instead of 7700. Any help will be greatly appreciated.

  .Cells(iRow, 6) = UserForm1.txtMaterial & (UserForm1.txtSeries.Value + UserForm1.txtSurface.Value) & "-" & UserForm1.txtWidth.Value & IIf(UserForm1.CbIN.Value = True, "IN", "MM")

Thanks

 

[Rick Rothstein]

Try wrapping each TextBox value with a CDbl function call...

  .Cells(iRow, 6) = UserForm1.txtMaterial & (CDbl(UserForm1.txtSeries.Value) + CDbl(UserForm1.txtSurface.Value)) & "-" & UserForm1.txtWidth.Value & IIf(UserForm1.CbIN.Value = True, "IN", "MM")

 

[isaacv22]

Try wrapping each TextBox value with a CDbl function call...

  .Cells(iRow, 6) = UserForm1.txtMaterial & (CDbl(UserForm1.txtSeries.Value) + CDbl(UserForm1.txtSurface.Value)) & "-" & UserForm1.txtWidth.Value & IIf(UserForm1.CbIN.Value = True, "IN", "MM")

Thank you very much Rick, worked like a charm. I appreciate your assistance!