Displaying the result of a formula in a text box

[julesl]

I have a user form with combo and text boxes.

Based on the values in three of the boxes I need the result of a formula to be displayed in a read only text box. The values selected in the 2 combo boxes determines which formula is used and the value in the text box is used in the formula

E.g

Combobox1 = 1111111
Combobox2 = Monthly
Textbox1 = 27.35

Formulas

1111111 & Monthly = (Textbox1/1.05)/1.08)*0.3)*12)
2222222 & Monthly = (Textbox1/1.05)/1.08)*0.25)*12)
3333333 & Annual = (Textbox1/1.05)/1.08)*0.3)

Result

Testbox 2 = 86.83

Can anyone help me with this please as I'm not sure where to start

Thanks

Jules

[Bob Phillips]

If Combobox2.Value = "Monthly" Then
If Combobox1.Value = "1111111" Then
Textbox1.Text = CDbl(Textbox1.Text) / 1.05 / 1.08 * 0.3 * 12
ElseIf Combobox1.Value = "222222" Then
Textbox1.Text = CDbl(Textbox1.Text) / 1.05 / 1.08 * 0.25 * 12
End If
ElseIf Combobox2.Value = "Annual" And _
Combobox1.Value = "333333" Then
Textbox1.Text = CDbl(Textbox1.Text) / 1.05 / 1.08 * 0.3
End If

--
HTH

Bob Phillips

"julesl" <[email protected]> wrote in
message news:[email protected]...
>
> I have a user form with combo and text boxes.
>
> Based on the values in three of the boxes I need the result of a
> formula to be displayed in a read only text box. The values selected in
> the 2 combo boxes determines which formula is used and the value in the
> text box is used in the formula
>
> E.g
>
> Combobox1 = 1111111
> Combobox2 = Monthly
> Textbox1 = 27.35
>
> Formulas
>
> 1111111 & Monthly = (Textbox1/1.05)/1.08)*0.3)*12)
> 2222222 & Monthly = (Textbox1/1.05)/1.08)*0.25)*12)
> 3333333 & Annual = (Textbox1/1.05)/1.08)*0.3)
>
> Result
>
> Testbox 2 = 86.83
>
> Can anyone help me with this please as I'm not sure where to start
>
> Thanks
>
> Jules
>
>
> --
> julesl
> ------------------------------------------------------------------------
> julesl's Profile:
http://www.excelforum.com/member.php...o&userid=25180
> View this thread: http://www.excelforum.com/showthread...hreadid=386711
>