Formula help...

[buzz71023]

I need some formula help. I have a userform calculator with 5 text boxes (txtAmtReq, txtAmtPrcd, txtRemnReq, txtRate, and txtTimeRemn)

Writing out this formula would be

(txtAmtReq - txtAmtPrcd = txtRemnReq) (TxtRemnReq / txtRate = txtTimeRemn)

I need it to be all one formula so when I hit my calculate button on my userform it all calculates correctly

I have this much working

txtTimeRemn =(txtAmtReq - txtAmtPrcd)/txtRate

Only problem with this formula is I still need the txtRemnReq to show its results (txtAmtReq - txtAmtPrcd)
<!-- / message -->

 

[Roli001]

I need some formula help. I have a userform calculator with 5 text boxes (txtAmtReq, txtAmtPrcd, txtRemnReq, txtRate, and txtTimeRemn)

Writing out this formula would be

(txtAmtReq - txtAmtPrcd = txtRemnReq) (TxtRemnReq / txtRate = txtTimeRemn)

I need it to be all one formula so when I hit my calculate button on my userform it all calculates correctly

I have this much working

txtTimeRemn =(txtAmtReq - txtAmtPrcd)/txtRate

Only problem with this formula is I still need the txtRemnReq to show its results (txtAmtReq - txtAmtPrcd)
<!-- / message -->

Sub TwoValuesOneAnswer()

    MsgBox ("TxtRemnReq = " & txtAmtReq - txtAmtPrcd _
    & ". txtTimeRemn = " & (txtAmtReq - txtAmtPrcd) / txtRate)

End Sub