Adding the value of 2 textboxes together

[brianfosterblack]

What am I doing wrong here
I want to add the values in the two textboxes together

  ActiveCell.Offset(, 9).FormulaLocal = FrmNew.TextBox11.Value + FrmNew.TextBox13.Value

Textbox 11 has a value of 300 in it and the other has 500 in, I want the result in currency but I am getting 300 500 instead of 800

 

[dmt32]

Hi,
try this update to your code

Private Sub CommandButton1_Click()
  ActiveCell.Offset(, 9).FormulaLocal = Val(Me.TextBox11.Value) + Val(Me.TextBox13.Value)
End Sub

Dave

 

[brianfosterblack]

Hi,
try this update to your code

Private Sub CommandButton1_Click()
  ActiveCell.Offset(, 9).FormulaLocal = Val(Me.TextBox11.Value) + Val(Me.TextBox13.Value)
End Sub

Dave

Thank you, this works perfectly. Appreciate the help

 

[dmt32]

Thank you, this works perfectly. Appreciate the help

welcome - appreciate the feedback

Dave