hi
I try making textbox contain specific currency , number format in textbox5,6 whether write in textbox or search by combobox . should show like this LYD 1,000.00
but it gives mismatch in this line
theses codes cuase the problem
Code
Private Sub TextBox6_Change()
Dim s As Currency
s = "LYD"
Me.TextBox6.Value = s & Format(CDbl(TextBox6.Value), "#,##0.00")
End Sub
Private Sub TextBox7_Change()
Dim s As Currency
s = "LYD"
Me.TextBox7.Value = s & Format(CDbl(TextBox7.Value), "#,##0.00")
End Sub
Display More
is there any idea to achieve that?