User Form Addition

[Guzzlr]

Hello All

Private Sub Btn_Find_Budget_Click()
On Error GoTo Error_Handler

If (Tbx_REV = vbNullString) Or (Tbx_Actual = vbNullString) Then
    MsgBox ("To Compute Budget:" _
    & vbNewLine & "REV & Actual fields require an input")
    Exit Sub
End If
Tbx_Budget = (Tbx_REV + Tbx_Actual)
Error_Handler:
MsgBox "Test"

I'm not understanding something here...
I have:
Tbx_Actual = (Tbx_Budget - Tbx_REV)

&

Tbx_Budget = (Tbx_REV + Tbx_Actual)

The subtraction in the Tbx_Actual works correctly. However, the Tbx_Budget combines the two numbers instead of summing them.
If I have Tbx_REV = 2 and I have Tbx_Actual =4. The output in Tbx_Budget = 24, instead of 6.

Why is this? How do I sum Tbx_REV and Tbx_Actual?

Thanks for the help
excel 2013

 

[Guzzlr]

Tbx_Complete.Value = Val(Tbx_Actual.Value) / Val(Tbx_Budget.Value)
Style = "Percent"

One more question. I'm trying to have Tbx_Complete.Value as a percentage answer, instead of simply multiplying the whole thing by 100

Thanks

 

[Fluff]

Try

Tbx_Complete.Value = Format(Tbx_Complete.Value, "0%")

 

[Guzzlr]

Try

Tbx_Complete.Value = Format(Tbx_Complete.Value, "0%")

Thank You

 

[Fluff]

Your welcome