calculation amounts with currency in textboxes on userform

[Abdo]

Hello
I want to add currency before amount for some textboxes manually and some textboxes should show amount with currency
when enter number in textbox1 will add currency as what I did it here
Private Sub TextBox1_AfterUpdate()
Dim CRR As String
CRR = "LYD"
TextBox1.Value = s & Format(TextBox1, "#,##0.00")
End Sub
when fill textbox1,3 will show result in textbox2 as marked in the picture
textbox2= textbox1/textbox3 then should show amount in textbox2 with currency as in this picture as marked

when fill textbox4 then
textbox5 = (textbox 1-textbox2)*textbox 4 but I would show minus value in textbox5 with currency as marked in this picture

I hope find way to do that.

 

[ranman256]

normally you dont mix values like that.
cant you just add a box for the currency type in front of the value box?

 

[Abdo]

bad news !
I thought to could do by mix amount with text !